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
