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