Re: BUG #2913: Subscript on multidimensional array yields no value

I can confirm this is a bug. Added to the TODO list:

o ARRAY[[1,2],[3,4]])[1] should return the same values as
ARRAY[[1,2],[3,4]])[1:1];

---------------------------------------------------------------------------

Roman Nowak wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2913
> Logged by: Roman Nowak
> Email address: roman_nowak(at)poczta(dot)onet(dot)pl
> PostgreSQL version: 8.2.1
> Operating system: Windows XP
> Description: Subscript on multidimensional array yields no value
> Details:
>
> SELECT (ARRAY[[1,2],[3,4]])[1];
>
> does not return [1,2]
> (testes in psql and pgAdmin III): show info that one row was returned but
> does not display its value
>
> following statment works OK btw
> SELECT (ARRAY[[1,2],[3,4]])[1:1];
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +