Re: Iterate OLD/NEW columns in a trigger?

On Apr 7, 2005, at 3:44 PM, Scott Marlowe wrote:

> On Thu, 2005-04-07 at 14:35, Steve - DND wrote:
>> Is there a way to iterate the columns contained on the OLD/NEW. I
>> want to do
>> some work in a function in a trigger, but I want it to be generic. I
>> don't
>> want to have to create a separate trigger for each table, since the
>> work
>> performed in the trigger is essentially the same for all of them. I
>> just
>> need to be able to dynamically find the columns associated with
>> OLD/NEW to
>> make it work. I didn't see anything in the docs about this, anyone
>> have a
>> solution?
>
> try pltcl, it's supposed to be pretty good at this.
>

As is plperl and likely plpython, and maybe others.

Sean