Is there a simple notation for comparing most columns in the new and old
records in a pl/pgsql trigger function?  Something like

(new.b, new.c, new.d) = (old.b, old.c, old.d)

works to compare all the columns except 'a', but is fragile in that it
needs to be updated any time a column is added to the table, and is rather
messy looking when the actual table has many columns.

Is there a better approach to detecting a change in any column except a few
specific ones?


* <mike.blackw...@rrd.com>*

Reply via email to