Quick Links

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

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Cédric Dufour <cedric(dot)dufour(at)freesurf(dot)ch>
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR
Date:	2002-08-02 19:40:12
Message-ID:	14626.1028317212@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

=?iso-8859-1?Q?C=E9dric_Dufour?= <cedric(dot)dufour(at)freesurf(dot)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

In response to

b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR at 2002-08-01 23:47:36 from Cédric Dufour

Responses

Re: b1 OR b2 <-> ( CASE WHEN b1 THE true ELSE b2 END ): performance bottleneck on logical OR at 2002-08-02 22:47:19 from Cédric Dufour

Browse pgsql-general by date

	From	Date	Subject
Next Message	scott.marlowe	2002-08-02 19:54:09	Re: How i can empty the buffers of a db
Previous Message	Tom Lane	2002-08-02 19:30:18	Re: Questions regarding contrib/tsearch