NEW and OLD as ROWS

From: Craig Servin <cservin(at)cromagnon(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: NEW and OLD as ROWS
Date: 2005-08-03 17:52:24
Message-ID: 200508031252.24844.cservin@cromagnon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-08-04 13:38:23 Re: NEW and OLD as ROWS
Previous Message codeWarrior 2005-08-03 15:38:18 Re: Breakdown results by month