BUG #2913: Subscript on multidimensional array yields no value

From: "Roman Nowak" <roman_nowak(at)poczta(dot)onet(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2913: Subscript on multidimensional array yields no value
Date: 2007-01-19 14:50:24
Message-ID: 200701191450.l0JEoOls011421@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs pgsql-patches


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];

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2007-01-19 15:49:33 Re: BUG #2905: min and max return incorrect text type
Previous Message Milton César de Souza Leite 2007-01-19 12:18:27 PostgreSQL & Slackware

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2007-01-20 21:56:04 Re: [DOCS] v8.2 US documentation
Previous Message Jeff Frost 2007-01-17 20:14:55 Re: Urgent Postgresql requirement.

Browse pgsql-patches by date

  From Date Subject
Next Message FAST PostgreSQL 2007-01-19 15:28:13 pg_get_domaindef
Previous Message Alvaro Herrera 2007-01-19 14:13:36 Re: partial pg_regress patch from Magnus