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

[Bruce Momjian <bruce(at)momjian(dot)us>]

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