ARRAY() returning NULL instead of ARRAY[] resp. {}

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: ARRAY() returning NULL instead of ARRAY[] resp. {}
Date: 2005-05-23 18:33:39
Message-ID: 1116873219.7306.0.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-sql

Hi,

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

Markus

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan B. 2005-05-23 18:54:07 Re: ARRAY() returning NULL instead of ARRAY[] resp. {}
Previous Message Josh Berkus 2005-05-23 17:26:27 Re: Obtaining Firing Statement clause in (pl/perlu) Trigger Function

Browse pgsql-patches by date

  From Date Subject
Next Message Jan B. 2005-05-23 18:54:07 Re: ARRAY() returning NULL instead of ARRAY[] resp. {}
Previous Message Bruce Momjian 2005-05-23 17:13:47 Remove unnecessary parentheses

Browse pgsql-sql by date

  From Date Subject
Next Message Jan B. 2005-05-23 18:54:07 Re: ARRAY() returning NULL instead of ARRAY[] resp. {}
Previous Message Andreas Kretschmer 2005-05-23 11:41:40 Re: [despammed] Re: Need clarification