X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8778DD1E985 for ; Wed, 21 Jan 2004 18:33:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 06434-03 for ; Wed, 21 Jan 2004 14:32:54 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 41D5ED1EAC8 for ; Wed, 21 Jan 2004 14:11:42 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0LIBcpH002598; Wed, 21 Jan 2004 13:11:38 -0500 (EST) To: Joe Conway Cc: Rajesh Kumar Mallah , pgsql-sql@postgresql.org Subject: Re: array_lower /array_prepend doubt In-reply-to: <400EBEF0.6060005@joeconway.com> References: <400E85EC.4000106@trade-india.com> <1648.1074705270@sss.pgh.pa.us> <400EBEF0.6060005@joeconway.com> Comments: In-reply-to Joe Conway message dated "Wed, 21 Jan 2004 10:03:28 -0800" Date: Wed, 21 Jan 2004 13:11:38 -0500 Message-ID: <2597.1074708698@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/198 X-Sequence-Number: 16591 Joe Conway writes: > Tom Lane wrote: >> Because array_prepend keeps the subscripts of the existing array >> elements the same. This was discussed during development of the >> code, but I don't see anything in the documentation that mentions it. > It could perhaps be added to the "Functions and Operators" page for > arrays, but it is mentioned here: > http://www.postgresql.org/docs/current/static/arrays.html#AEN5183 Ah. I was looking at the mentions of array_prepend() ... but of course the manual also says that you should use the || operator instead ... so I guess this mention is sufficient. The other point about pg_dump failing to correctly restore arrays with nondefault lower bounds is a good one, though. We need to think about how to fix that. regards, tom lane