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>
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 |
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. {} |
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? |