Re: short ciruit logic of plpgsql in 8.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: short ciruit logic of plpgsql in 8.2
Date: 2007-05-17 21:39:21
Message-ID: 13381.1179437961@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Broersma Jr <rabroersma(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2007-05-17 21:40:02 Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)
Previous Message Ron Johnson 2007-05-17 21:16:54 Re: Large Database Restore