Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3477A9FB35C for ; Tue, 30 Jan 2007 22:00:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 71908-01 for ; Tue, 30 Jan 2007 22:00:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id D20A79FB408 for ; Tue, 30 Jan 2007 22:00:30 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l0V20Sd08345; Tue, 30 Jan 2007 21:00:28 -0500 (EST) From: Bruce Momjian Message-Id: <200701310200.l0V20Sd08345@momjian.us> Subject: Re: BUG #2913: Subscript on multidimensional array yields no value In-Reply-To: <13671.1170202751@sss.pgh.pa.us> To: Tom Lane Date: Tue, 30 Jan 2007 21:00:28 -0500 (EST) CC: Roman Nowak , pgsql-bugs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/175 X-Sequence-Number: 16792 Tom Lane wrote: > Bruce Momjian writes: > > 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]; > > This is not a bug, this is a definitional disagreement, and your TODO > entry presupposes an answer that I don't particularly agree with. Well, our documentation suggests thaat [1] is the same as [1:1]: http://www.postgresql.org/docs/8.2/static/arrays.html#AEN5791 What is the issue here that makes that not true? -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +