Steve Atkins <[EMAIL PROTECTED]> writes:
> IF TG_OP='INSERT' OR NEW.foo != OLD.foo THEN
> -- do stuff
> Is there anything that guarantees that the NEW.foo != OLD.foo won't
> be evaluated (and hence fail, as there is no OLD) on an insert?
The only way is to split the expression into two IF commands. The real
problem is not with the evaluation per se, but with plpgsql having to
pass down all the variable values used in the expression before
evaluation can start.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
