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@poczta.onet.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@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
