Short-circuit boolean evaluation - Mailing list pgsql-general

From Jon Smark
Subject Short-circuit boolean evaluation
Date
Msg-id 471279.1444.qm@web112813.mail.gq1.yahoo.com
Whole thread Raw
Responses Re: Short-circuit boolean evaluation
List pgsql-general
Hi,

Does Postgresql perform short-circuit boolean evaluation both in SQL
and PL/pgSQL functions?  As an example, suppose I have a function called
"do_stuff" which is computationally intensive.  In the example below,
will it be called for rows for which the first predicate (foobar.id = $1)
is false?

SELECT count(*) FROM foobar WHERE foobar.id = $1 AND do_stuff (foobar.name);

Thanks!
Jon


pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Switching Database Engines
Next
From: pasman pasmański
Date:
Subject: Re: Short-circuit boolean evaluation