NEW and OLD as ROWS - Mailing list pgsql-sql

From Craig Servin
Subject NEW and OLD as ROWS
Date
Msg-id 200508031252.24844.cservin@cromagnon.com
Whole thread Raw
Responses Re: NEW and OLD as ROWS  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "codeWarrior"
Date:
Subject: Re: Breakdown results by month
Next
From: Michael Fuhr
Date:
Subject: Re: NEW and OLD as ROWS