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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
