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

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 to log 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 get an array of fields from the Record.

This might help you:

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




John DeSoi, Ph.D.