Skip site navigation (1) Skip section navigation (2)

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

From: "y(dot)y(dot)chen" <segma(dot)yychen(at)msa(dot)hinet(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5576: Boolean operation should not be Complete boolean evaluation
Date: 2010-07-29 11:40:18
Message-ID: 201007291140.o6TBeIis043892@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5576
Logged by:          y.y.chen
Email address:      segma(dot)yychen(at)msa(dot)hinet(dot)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!

Responses

pgsql-bugs by date

Next:From: y.y.chenDate: 2010-07-29 13:11:28
Subject: BUG #5577: Boolean operation should not be Complete boolean evaluation
Previous:From: Tom LaneDate: 2010-07-28 17:23:24
Subject: Re: failed to fetch tuple for EvalPlanQual recheck

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group