Re: Iterate OLD/NEW columns in a trigger?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Iterate OLD/NEW columns in a trigger?
Дата
Msg-id 1112903061.20921.58.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Iterate OLD/NEW columns in a trigger?  ("Steve - DND" <postgres@digitalnothing.com>)
Ответы Re: Iterate OLD/NEW columns in a trigger?  (Sean Davis <sdavis2@mail.nih.gov>)
Список 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 по дате отправления:

Предыдущее
От: "Steve - DND"
Дата:
Сообщение: Iterate OLD/NEW columns in a trigger?
Следующее
От: Sean Davis
Дата:
Сообщение: Re: Iterate OLD/NEW columns in a trigger?