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 <pasma...@gmail.com> wrote: > No. > > 2011/4/30, Jon Smark <jon.sm...@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
