Re: pl/pgsql short circuit evaluation? - Mailing list pgsql-novice

From Tom Lane
Subject Re: pl/pgsql short circuit evaluation?
Date
Msg-id 2341.1235678210@sss.pgh.pa.us
Whole thread Raw
In response to pl/pgsql short circuit evaluation?  (david@gardnerit.net)
List pgsql-novice
david@gardnerit.net writes:
> First does pl/pgSQL do short circuit evaluation?

Not in the sense you're looking for.  The entire IF expression is passed
to the evaluator at once and all the plpgsql-level variables in it have
to be available at the start.

            regards, tom lane

pgsql-novice by date:

Previous
From: david@gardnerit.net
Date:
Subject: pl/pgsql short circuit evaluation?
Next
From: Yuichi Tanaka
Date:
Subject: Unable to open large object.