Getting INSERT values on a trigger

Поиск
Список
Период
Сортировка
От Hitesh Patel
Тема Getting INSERT values on a trigger
Дата
Msg-id 396B98BA.4263CAAB@presys.com
обсуждение исходный текст
Список pgsql-interfaces
I am trying to use a C function to get the values inputted for a given
row.  I have defined the trigger as:
CREATE TRIGGER test AFTER INSERT OR UPDATE OR DELETE on testrel FOR
EACH ROW EXECUTE PROCEDURE testfunc();

Now say if I do a 'INSERT INTO testrel VALUES('1','string');' how can I
grab the values for each field within testfunc() and act on them (in
this case spit them out to another file)?

I have read the docs and can't seem to find how to retrieve the
values...

-- 
+---------------------------------+----------------------------+
| Hitesh Patel                    |  Voice: (541) 759-3126     |
|                                 |  Fax:   (541) 759-3214     |
| Preferred Communications Inc.      |  Email: hitesh@pciwest.net |
+---------------------------------+----------------------------+

perl -e 'print pack("B*", "0100100100100000011101000110100001" .
"101001011011100110101100100000010010010010000001100100011100" .
"100110000101101110011010110010000001110011011011110110110101" .
"100101001000000110001001100001011001000010000001001110011110" .
"010111000101110101011010010110110000001010");'


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

Предыдущее
От: Allan Kelly
Дата:
Сообщение: Re: odbc, postgresql and cobalt Qube/RaQ3
Следующее
От: "XWorkers"
Дата:
Сообщение: ODBC -- how much stable through internet