I am writing an update trigger that I want to fire when any field changes. It looks like two ROWS can be compared very easily, but not the two RECORDS OLD and NEW.
Is there a way to do:
NEW IS DISTINCT FROM OLD
in a trigger?
This would help me not have to write a specific trigger for each table.
Thanks,
Craig
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
