Question about accessing current row data inside trigger

Поиск
Список
Период
Сортировка
От peter Willis
Тема Question about accessing current row data inside trigger
Дата
Msg-id 422DFEEA.7010207@borstad.com
обсуждение исходный текст
Ответы Re: Question about accessing current row data inside trigger  (Michael Fuhr <mike@fuhr.org>)
Re: Question about accessing current row data inside trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,

I have a trigger function written in C.
The trigger function is called via:

CREATE TRIGGER after_update AFTER UPDATE ON some_table
    FOR EACH ROW EXECUTE PROCEDURE  my_trigger_function();

    Since the trigger is called after each row update the actual row data
should be available in some way to the trigger.
    What functionality (SPI ?) do I use to use the column values from
the current row in the actual trigger?

thanks for any insight,

Peter



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

Предыдущее
От: Edmund Bacon
Дата:
Сообщение: Re: Stuck with a query...
Следующее
От: "Raghunath Ganti"
Дата:
Сообщение: Postgres - Tsearch2 Module