| 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: | Whole Thread | Raw Message | 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? |