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

From Steve - DND
Subject Iterate OLD/NEW columns in a trigger?
Date
Msg-id LDEHKBBOEMIJKHKBOFNFEEDLMIAA.postgres@digitalnothing.com
Whole thread Raw
Responses Re: Iterate OLD/NEW columns in a trigger?  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
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?

Thanks,
Steve



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: seg fault with tsearch2
Next
From: Scott Marlowe
Date:
Subject: Re: Iterate OLD/NEW columns in a trigger?