Re: Empty array IS NULL?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Empty array IS NULL?
Date: 2004-06-28 19:05:24
Message-ID: 87isdb1p1n.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Markus Bertheau <twanger(at)bluetwanger(dot)de> writes:

> oocms=# SELECT ARRAY(SELECT 1 WHERE FALSE);
> ?column?
> ----------
>

This one seems strange to me. Shouldn't it result in an empty array?

--
greg

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stefan Weiss 2004-06-28 22:02:29 "=" operator vs. "IS"
Previous Message beyaNet 2004-06-28 18:27:13 unsubscribe