Re: [BUGS] BUG #5576: Boolean operation should not be Complete boolean evaluation

2010-07-29 Thread Tom Lane
"y.y.chen" 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

[BUGS] BUG #5577: Boolean operation should not be Complete boolean evaluation

2010-07-29 Thread y.y.chen
The following bug has been logged online: Bug reference: 5577 Logged by: y.y.chen Email address: yyc...@mail.clhs.tyc.edu.tw PostgreSQL version: 8.4.x Operating system: WINDOWS-XP Description:Boolean operation should not be Complete boolean evaluation Details: It's

[BUGS] BUG #5576: Boolean operation should not be Complete boolean evaluation

2010-07-29 Thread y.y.chen
The following bug has been logged online: Bug reference: 5576 Logged by: y.y.chen Email address: segma.yyc...@msa.hinet.net PostgreSQL version: 8.4.x Operating system: WINDOWS-XP Description:Boolean operation should not be Complete boolean evaluation Details: When