Are we not allowed to use NEW and OLD in an EXECUTEd statement?

Postgresql 7.1 beta 4

Received:
ERROR:  NEW used in non-rule query

from within a plpgsql function (using an EXECUTE statement of course).

That aside, is there anyway to do:

v_var := NEW.v_variable;

As it would be an acceptable alternative.

--
Rod Taylor

There are always four sides to every story: your side, their side, the
truth, and what really happened.
BEGIN:VCARD
VERSION:2.1
N:Taylor;Rod;B
FN:Taylor, Rod B
ORG:BarChord Entertainment Inc.;System Operation and Development
TITLE:Chief Technical Officer
ADR;WORK:;;;Toronto;Ontario;;Canada
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Toronto, Ontario=0D=0ACanada
X-WAB-GENDER:2
URL:
URL:http://www.barchord.com
BDAY:19790401
EMAIL;INTERNET:[EMAIL PROTECTED]
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
EMAIL;INTERNET:[EMAIL PROTECTED]
REV:20010213T181353Z
END:VCARD

Reply via email to