C.
Klaus Sonnenleiter wrote, On 12/31/2002 3:25 PM:
I think the question was how to find out which columns were affected by the update statement. TG_OP will only tell you whether an update fired the trigger.
Klaus
On Thursday 26 December 2002 03:29, CoL wrote:
http://www.postgresql.org/idocs/index.php?trigger-manager.html http://www.postgresql.org/idocs/index.php?plpgsql-trigger.html TG_OP ?C. shreedhar wrote, On 12/26/2002 12:57 PM: > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
