"Richard Broersma" <[EMAIL PROTECTED]> writes:
> I could manually expand the composite type OLD and NEW to enumerate
> each field and make a row wise comparison. However, I was hoping to
> avoid that.
I think IF ROW(NEW.*) <> ROW(OLD.*) will work in recent releases.
Actually you'd better use IF ROW(NEW.*) IS DISTINCT FROM ROW(OLD.*) ...
you really don't want to rely on <> as it will not give the behavior
you want in the presence of null columns.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
