Re: wierd AND condition evaluation for plpgsql

From: Alessio Bragadini <alessio(at)albourne(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: wierd AND condition evaluation for plpgsql
Date: 2002-05-30 13:04:19
Message-ID: 1022763862.3447.6658.camel@iris
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)joel=# select false and seeme();

> joel(at)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(at)albourne(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Burton 2002-05-30 13:21:17 Re: wierd AND condition evaluation for plpgsql
Previous Message Andrew Sullivan 2002-05-30 12:22:59 Re: Replication status