Postgres Pro
Downloads
Home   >   mailing lists

Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR - Mailing list pgsql-general

From Tom Lane
Subject Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR
Date
Msg-id 14626.1028317212@sss.pgh.pa.us
Whole thread Raw
In response to b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR  (Cédric Dufour <cedric.dufour@freesurf.ch>)
Responses Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR  (Cédric Dufour <cedric.dufour@freesurf.ch>)
List pgsql-general
Tree view 
=?iso-8859-1?Q?C=E9dric_Dufour?= <cedric.dufour@freesurf.ch> writes:
> This tends to prove that the normal OR expression evaluates both left and
> right expression, though evaluating the right expression is useless provided
> the left expression is true.

It proves no such thing.  How about showing us what you actually did,
rather than jumping to (incorrect) conclusions?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Questions regarding contrib/tsearch
Next
From: Tom Lane
Date:
Subject: Re: custom type similar to varchar(#)