Home > mailing lists

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

From	Markus Bertheau
Subject	ARRAY() returning NULL instead of ARRAY[] resp. {}
Date	May 23, 2005 18:33:56
Msg-id	1116873219.7306.0.camel@localhost.localdomain Whole thread Raw
Responses	Re: ARRAY() returning NULL instead of ARRAY[] resp. {} ("Jan B." <jan@monso.de>) Re: ARRAY() returning NULL instead of ARRAY[] resp. {} (Joe Conway <mail@joeconway.com>)
List	pgsql-sql

Hi,

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

Markus

--
Markus Bertheau <twanger@bluetwanger.de>

From: Andreas Kretschmer
Date: 23 May 2005, 11:39:36
Subject: Re: [despammed] Re: Need clarification

From: "Jan B."
Date: 23 May 2005, 18:53:05
Subject: Re: ARRAY() returning NULL instead of ARRAY[] resp. {}