Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records) - Mailing list pgsql-general

On Apr 28, 2011, at 3:46 PM, Basil Bourque wrote:

> It seems that I cannot get PL/pgSQL to interpret the text of "NEW." + column name as text.
>
> My goal is to loop each field in a trigger, comparing the "OLD." & "NEW." values of each field. If different I want
tolog both values in a history/audit-trail table. 
>
> Is there some way to loop the fields of a trigger's Record? I've read other people's frustration at not being able to
getan array of fields from the Record. 

This might help you:

http://wiki.postgresql.org/wiki/PL/pgSQL_Dynamic_Triggers




John DeSoi, Ph.D.