Metadata from NEW and OLD constructs?

From: "Lenorovitz, Joel" <Joel(dot)Lenorovitz(at)usap(dot)gov>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Metadata from NEW and OLD constructs?
Date: 2006-12-12 01:19:33
Message-ID: 7119BB016BDF6445B20A4B9F14F50B2D44A8D5@WILSON.usap.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

I was wondering if it's possible to get any of the metadata from the NEW
and OLD constructs in a trigger or view rule? Specifically, I'd like to
get the column name or identifier anywhere the new record differs from
the old record (i.e. NEW.column_X <> OLD.column_X). Any advice would be
greatly appreciated.

Thanks,
JL

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-12-12 01:37:04 Re: PITR and moving objects between table spaces
Previous Message Tom Lane 2006-12-12 00:53:43 Re: forcing compression of text field