"Graeme Merrall" <gbmerrall(at)aol(dot)com> writes:
> The function below will update the 'dirty' column as long as you're not
> performing an operation on the 'dirty' as part of your SQL statement
> CREATE OR REPLACE TRIGGER before_nodes_update
> before update on nodes
> for each row
> begin
> if not updating('DIRTY') then
Hmm. The usual locution in Postgres is more like
if old.foo != new.foo then ...
Is that close enough to do what you want?
regards, tom lane