From: | "shreedhar" <shreedhar(at)lucidindia(dot)net> |
---|---|
To: | "Postgres" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Is there any eqvivalent or alternative to UPDATE(column) or COLUMNS_UPDATED() of SQLServer2000 |
Date: | 2002-03-15 11:57:30 |
Message-ID: | 000601c1cc18$97f37200$1201a8c0@a4005 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Is there any eqvivalent or alternative to the following IF UPDATE(column) or
IF(COLUMNS_UPDATED()) of SQLServer2000.
IF UPDATE (column)
Tests for an INSERT or UPDATE action to a specified column and is not used
with DELETE operations. More than one column can be specified. Because the
table name is specified in the ON clause, do not include the table name
before the column name in an IF UPDATE clause. To test for an INSERT or
UPDATE action for more than one column, specify a separate UPDATE(column)
clause following the first one. IF UPDATE will return the TRUE value in
INSERT actions because the columns have either explicit values or implicit
(NULL) values inserted.
IF (COLUMNS_UPDATED())
Tests, in an INSERT or UPDATE trigger only, whether the mentioned column or
columns were inserted or updated. COLUMNS_UPDATED returns a varbinary bit
pattern that indicates which columns in the table were inserted or updated.
Thanks And Regards,
Sreedhar
"Faith, faith, faith in ourselves, faith, faith in God, this is the secret
of greatness.
If you have faith in all the three hundred and thirty millions of your
mythological gods,
and in all the gods which foreigners have now and again introduced into your
midst,
and still have no faith in yourselves, there is no salvation for you. "
(III. 190)
From | Date | Subject | |
---|---|---|---|
Next Message | S.F. Lee | 2002-03-15 12:03:28 | 7.2 occupy big hard disk space |
Previous Message | Jean-Christophe FABRE | 2002-03-15 11:33:51 | backup database under cygwin |