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@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. +