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

From: Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Joe Conway <mail(at)joeconway(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}
Date: 2005-06-06 14:54:59
Message-ID: 1118069699.5506.9.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-sql

В Пнд, 06/06/2005 в 10:44 -0400, Tom Lane пишет:
> Markus Bertheau =?UTF-8?Q?=E2=98=AD?= <twanger(at)bluetwanger(dot)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(at)bluetwanger(dot)de>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonah H. Harris 2005-06-06 15:10:07 Re: graphical representaion of the catalogue
Previous Message Jonah H. Harris 2005-06-06 14:52:56 Re: need help

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2005-06-06 15:27:07 Re: Faster install-sh in C
Previous Message Tom Lane 2005-06-06 14:44:49 Re: ARRAY() returning NULL instead of ARRAY[] resp. {}

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2005-06-06 15:39:48 Re: ARRAY() returning NULL instead of ARRAY[] resp. {}
Previous Message Richard Huxton 2005-06-06 14:45:02 Re: What is faster?