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 majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly