Re: ARRAY() returning NULL instead of ARRAY[] resp. {} - Mailing list pgsql-sql

Markus Bertheau wrote:
> why does SELECT ARRAY(SELECT 1 WHERE FALSE) return NULL instead of
> ARRAY[] resp. '{}'?
> 

Why would you expect an empty array instead of a NULL? NULL is what 
you'd get for other data types -- for example:

regression=# SELECT (SELECT 1 WHERE FALSE) IS NULL; ?column?
---------- t
(1 row)

Joe