"Richard Broersma" <richard.broersma@xxxxxxxxx> 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
