On Wed, Jun 25, 2008 at 8:17 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > 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. Thanks that worked! -- Regards, Richard Broersma Jr. Visit the Los Angles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
