From: | Timothy Seever <tricops1111(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Copying contents of OLD/NEW in a trigger |
Date: | 2002-09-04 23:42:07 |
Message-ID: | jTwd9.262209$f05.14248925@news1.calgary.shaw.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jerome Chochon | 2002-09-05 06:17:46 | PostgreSQL papers: The last time |
Previous Message | Johnson, Shaunn | 2002-09-04 20:52:01 | SOLVED: RE: unknown authentication type? |