Copying contents of OLD/NEW in a trigger

Поиск
Список
Период
Сортировка
От Timothy Seever
Тема Copying contents of OLD/NEW in a trigger
Дата
Msg-id jTwd9.262209$f05.14248925@news1.calgary.shaw.ca
обсуждение исходный текст
Список pgsql-general
I'm trying to copy the contents of old/new inside of a trigger
to pass to another function.  Is there any way to do this?

I've created a %ROWTYPE variable and tried both:

------------------------------
old_row := OLD;

and

select * into old_row from old;
------------------------------

The first gives a parse error, and the second gives the standard
error about using old in a non-rule query.  Is there no way to do
this without copying every column one by one?  I need to pass
pretty much every field of old/new to the function, and it seems
kind of absurd that I'd have to pass them all separately.

Any help would be much appreciated.

Thanks in advance,
   Tim Seever



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

Предыдущее
От: "Marcos Viera - PROYTEK, S.A."
Дата:
Сообщение: Create a database in qnx 4.25?
Следующее
От: fpaul@netcourrier.com
Дата:
Сообщение: PostgreSQL vs MySQL : strange results on insertion