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

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

Perhaps Arrays always have to contain at least one element? (I don't 
know for sure.)

SELECT array[];
ERROR:  syntax error at or near "]" at character 14
LINE 1: SELECT array[];

SELECT array[1]; array
------- {1}
(1 row)