Postgres Pro
Downloads
Home   >   mailing lists

Metadata from NEW and OLD constructs? - Mailing list pgsql-general

From Lenorovitz, Joel
Subject Metadata from NEW and OLD constructs?
Date
Msg-id 7119BB016BDF6445B20A4B9F14F50B2D44A8D5@WILSON.usap.gov
Whole thread Raw
Responses Re: Metadata from NEW and OLD constructs?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: forcing compression of text field
Next
From: Tom Lane
Date:
Subject: Re: PITR and moving objects between table spaces