Re: Short-circuit boolean evaluation

[David Johnston <polobo@xxxxxxxxx>]

No. It will not be called
Or
No. Postgresql does not short-circuit boolean evaluations
?

On Apr 30, 2011, at 10:27, pasman pasmaÅski <pasman.p@xxxxxxxxx> wrote:

No.

2011/4/30, Jon Smark <jon.smark@xxxxxxxxx>:

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

--

Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)

To make changes to your subscription:

http://www.postgresql.org/mailpref/pgsql-general

--
------------
pasman

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general