Passing arguments to a function called by a trigger

Поиск
Список
Период
Сортировка
От Some Developer
Тема Passing arguments to a function called by a trigger
Дата
Msg-id 51F3B52D.2010804@googlemail.com
обсуждение исходный текст
Ответы Re: Passing arguments to a function called by a trigger  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Passing arguments to a function called by a trigger  (Luca Ferrari <fluca1978@infinito.it>)
Список pgsql-novice
I have an INSERT AFTER trigger that runs on inserts into a specific
table. I'm not sure if the function automatically gets all the
information that was inserted into the table or whether you have to
manually pass it in?

If you do have to manually pass it in can someone point me to some
examples showing the correct syntax to use? I've read through the
PostgreSQL manual on C functions but most of the trigger examples don't
take any arguments unfortunately.

Also while I am on the subject can anyone recommend a good book on
stored procedure programming with PostgreSQL please? I use plpython2u
and C for my stored procedures if that makes any difference.

Thanks.


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

Предыдущее
От: Francisco Leovey
Дата:
Сообщение: Re: Using wildcard for table name ?
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Passing arguments to a function called by a trigger