Re: wierd AND condition evaluation for plpgsql - Mailing list pgsql-hackers

From Alessio Bragadini
Subject Re: wierd AND condition evaluation for plpgsql
Date
Msg-id 1022763862.3447.6658.camel@iris
Whole thread Raw
In response to Re: wierd AND condition evaluation for plpgsql  ("Joel Burton" <joel@joelburton.com>)
Responses Re: wierd AND condition evaluation for plpgsql
List pgsql-hackers
On Tue, 2002-05-28 at 16:09, Joel Burton wrote:

> Actually, at least in some cases, PG does short-circuit logic:

> joel@joel=# select false and seeme();

> joel@joel=# select true and seeme();

If seeme() returns NULL, shouldn't both SELECTs return NULL, and
therefore not be short-circuit-able?

Sorry, I am a little confused.

-- 
Alessio F. Bragadini        alessio@albourne.com
APL Financial Services        http://village.albourne.com
Nicosia, Cyprus             phone: +357-22-755750

"It is more complicated than you think"    -- The Eighth Networking Truth from RFC 1925



pgsql-hackers by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Replication status
Next
From: "Joel Burton"
Date:
Subject: Re: wierd AND condition evaluation for plpgsql