BUG #5576: Boolean operation should not be Complete boolean evaluation - Mailing list pgsql-bugs

From y.y.chen
Subject BUG #5576: Boolean operation should not be Complete boolean evaluation
Date
Msg-id 201007291140.o6TBeIis043892@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5576: Boolean operation should not be Complete boolean evaluation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5576
Logged by:          y.y.chen
Email address:      segma.yychen@msa.hinet.net
PostgreSQL version: 8.4.x
Operating system:   WINDOWS-XP
Description:        Boolean operation should not  be Complete boolean
evaluation
Details:

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'.


--------------------------------
It is happen in 8.3.11,8.4.1~8.4.4-1
But 9.0.0.beta 3 is OK!

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: failed to fetch tuple for EvalPlanQual recheck
Next
From: "y.y.chen"
Date:
Subject: BUG #5577: Boolean operation should not be Complete boolean evaluation