Postgres Pro
Downloads
Home   >   mailing lists

Re: short ciruit logic of plpgsql in 8.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: short ciruit logic of plpgsql in 8.2
Date
Msg-id 13381.1179437961@sss.pgh.pa.us
Whole thread Raw
In response to short ciruit logic of plpgsql in 8.2  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: short ciruit logic of plpgsql in 8.2
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: PFC
Date:
Subject: Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)
Next
From: PFC
Date:
Subject: Re: 8.0, UTF8, and CLIENT_ENCODING