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(dot)Blackwell(at)rrd(dot)com>*