Re: Empty array IS NULL? - Mailing list pgsql-sql

From Greg Stark
Subject Re: Empty array IS NULL?
Date
Msg-id 87isdb1p1n.fsf@stark.xeocode.com
Whole thread Raw
In response to Empty array IS NULL?  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
Markus Bertheau <twanger@bluetwanger.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



pgsql-sql by date:

Previous
From: beyaNet
Date:
Subject: unsubscribe
Next
From: Stefan Weiss
Date:
Subject: "=" operator vs. "IS"