Re: Verify a record has a column in a plpgsql trigger

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Verify a record has a column in a plpgsql trigger
Дата
Msg-id b42b73151002050708q4b524118q65b5ca9ff0b6ea79@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Verify a record has a column in a plpgsql trigger  (Tim Landscheidt <tim@tim-landscheidt.de>)
Ответы Re: Verify a record has a column in a plpgsql trigger  (Mike Ginsburg <mginsburg@collaborativefusion.com>)
Список pgsql-general
On Thu, Feb 4, 2010 at 7:36 PM, Tim Landscheidt <tim@tim-landscheidt.de> wrote:
>> Any insight on a way I can grab NEW.(colRow.attname) without EXECUTE USING?
>
> Wouldn't it be *much* easier to just have /two/ trigger
> functions? Your "editor" columns probably don't pop up and
> disappear randomly.

or, you could pass an argument to the trigger function from 'create
trigger'...you have to have one for each table anyways, and you could
wrap the trigger creation with some dyna-sql that looks up the editor
field and sets the argument appropriately,

merlin

В списке pgsql-general по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Query to find list of dates between two dates
Следующее
От: Moe
Дата:
Сообщение: Searching a DB index.. possible?