| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| Cc: | Steve - DND <postgres(at)digitalnothing(dot)com>, postgres-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Iterate OLD/NEW columns in a trigger? |
| Date: | 2005-04-07 21:16:34 |
| Message-ID: | bfc18d83d39a0a3010ad2e2869db0d4e@mail.nih.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve - DND | 2005-04-07 21:24:15 | Re: Iterate OLD/NEW columns in a trigger? |
| Previous Message | Scott Marlowe | 2005-04-07 19:44:21 | Re: Iterate OLD/NEW columns in a trigger? |