Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-docspgsql-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

pgsql-docs by date

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

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2007-01-19 15:49:33
Subject: Re: BUG #2905: min and max return incorrect text type
Previous:From: Milton C├ęsar de Souza LeiteDate: 2007-01-19 12:18:27
Subject: PostgreSQL & Slackware

pgsql-patches by date

Next:From: FAST PostgreSQLDate: 2007-01-19 15:28:13
Subject: pg_get_domaindef
Previous:From: Alvaro HerreraDate: 2007-01-19 14:13:36
Subject: Re: partial pg_regress patch from Magnus

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group