"y.y.chen" <segma.yyc...@msa.hinet.net> writes:
> When I run SQL -scripts in trigger/PlpgSQL:

> IF (TG_OP = 'INSERT') OR (old.size<>new.size) THEN
> .......
> END IF;

>  It raise a exception: RECORD old never be defined,
>  while TG_OP is 'INSERT'.

Yup, that's how it works.  SQL OR is not guaranteed to be short-circuit
in the same way it is in some programming languages.  You need to use
nested IF statements to make this work safely.

                        regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to