Re: Short-circuit boolean evaluation

No.

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

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@postgresql.org)

To make changes to your subscription:

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

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

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