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

From Markus Bertheau ☭
Subject Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}
Date
Msg-id 1118069699.5506.9.camel@dicaprio.akademie1.de
Whole thread Raw
In response to Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}
List pgsql-hackers
В Пнд, 06/06/2005 в 10:44 -0400, Tom Lane пишет:
> Markus Bertheau ☭ <twanger@bluetwanger.de> writes:
> > By analogy, array_upper('{}'::TEXT[], 1) should return 0 instead of
> > NULL.
> 
> No, that doesn't follow ... we've traditionally considered '{}' to
> denote a zero-dimensional array.

But array_upper(ARRAY(SELECT 1 WHERE FALSE), 1) should return 0,
and array_upper(ARRAY[], 1), when the ARRAY[] syntax is supported,
should return 0.

Do I get that right?

Markus

-- 
Markus Bertheau ☭ <twanger@bluetwanger.de>



pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: need help
Next
From: "Jonah H. Harris"
Date:
Subject: Re: graphical representaion of the catalogue