"Gauthier, Dave" <dave.gauth...@intel.com> writes:
> I get... "OLD used in query that is not in a rule" when trying to ref, for
> example, OLD.tblcol1, from inside a stored procedure. Is this saying you
> cannot use OLD.* (or NEW.* I suppose) unless it's from within a trigger
> function (returns type "trigger")?
Certainly. You'd have to pass the field (or whole record) as a
parameter. It's not some kind of magic global variable, it's
a predefined local variable in a trigger function (or rule).
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
