NEW and OLD in EXECUTE

From: "Rod Taylor" <rod(dot)taylor(at)inquent(dot)com>
To: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Subject: NEW and OLD in EXECUTE
Date: 2001-02-13 18:13:53
Message-ID: 0cd901c095e8$b94a4ee0$6500000a@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Attachment Content-Type Size
Taylor, Rod B.vcf text/x-vcard 451 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-02-13 18:23:14 Re: locale support
Previous Message Mikheev, Vadim 2001-02-13 18:11:31 RE: Recovery of PGSQL after system crash failing!!!