Re: Iterate OLD/NEW columns in a trigger? - Mailing list pgsql-general

From Sean Davis
Subject Re: Iterate OLD/NEW columns in a trigger?
Date
Msg-id bfc18d83d39a0a3010ad2e2869db0d4e@mail.nih.gov
Whole thread Raw
In response to Re: Iterate OLD/NEW columns in a trigger?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Iterate OLD/NEW columns in a trigger?
List pgsql-general
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


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Iterate OLD/NEW columns in a trigger?
Next
From: "Steve - DND"
Date:
Subject: Re: Iterate OLD/NEW columns in a trigger?