Re: Passing parameters to a Trigger

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Passing parameters to a Trigger
Дата
Msg-id 22388.1043776781@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Passing parameters to a Trigger  (Antonio Scotti <ascotti@mbigroup.it>)
Список pgsql-novice
Antonio Scotti <ascotti@mbigroup.it> writes:
>     The exact reference to what I've read is: in the .pdf file
> "programmer-7.2-A4.pdf" at the very beginning of page 240. It is the
> programmer's reference manual, the section regardings the CREATE TRIGGER
> command in the paragraph explaing the meaning of 'args'.
>     It says something about passing the current_user to a trigger but it
> is not clear to me so I'd like to have it explained.

No, what it's suggesting is passing two field names (constant strings)
to a trigger, which then uses those as the names of the fields to stick
current user and current time values into.  The trigger would have to
compute current user and current time for itself.

            regards, tom lane

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

Предыдущее
От: Steve_Miller@sil.org
Дата:
Сообщение: Re: Learning Plpgsql ??
Следующее
От: Steve_Miller@sil.org
Дата:
Сообщение: Re: collation