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

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

pgsql-general by date:

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