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

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

From: "y(dot)y(dot)chen" <yychen(at)mail(dot)clhs(dot)tyc(dot)edu(dot)tw>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5577: Boolean operation should not be Complete boolean evaluation
Date: 2010-07-29 13:11:28
Message-ID: 201007291311.o6TDBS5C094362@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5577
Logged by:          y.y.chen
Email address:      yychen(at)mail(dot)clhs(dot)tyc(dot)edu(dot)tw
PostgreSQL version: 8.4.x
Operating system:   WINDOWS-XP
Description:        Boolean operation should not  be Complete boolean
evaluation
Details: 

It's happen in version 8.3.11,8.4.1,8.4.4
but not in 9.0.0.beta3.

When I run in PlpgSQL /Trigger :

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

While TG_OP is 'INSERT' and then raise a exception
 RECORD old never be defined !

It's not an efficiency SQL-scripts for "Complete boolean evaluation "!

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-07-29 14:14:28
Subject: Re: BUG #5576: Boolean operation should not be Complete boolean evaluation
Previous:From: y.y.chenDate: 2010-07-29 11:40:18
Subject: BUG #5576: Boolean operation should not be Complete boolean evaluation

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