Re: short ciruit logic of plpgsql in 8.2

Richard Broersma Jr <rabroersma@yahoo.com> writes:
> Does anyone know if logic operations in plpgsql are short circuited in 8.2?

They are often optimized, but if you expect "short circuiting" following
exactly the rules of, say, C, you are likely to be disappointed.  See
the manual:

http://www.postgresql.org/docs/8.2/static/sql-expressions.html#SYNTAX-EXPRESS-EVAL

            regards, tom lane