X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 594D1D1D17D for ; Thu, 12 Feb 2004 15:11:01 +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 44307-07 for ; Thu, 12 Feb 2004 11:11:02 -0400 (AST) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 40C8BD1C9BE for ; Thu, 12 Feb 2004 11:10:57 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i1CFAcq18481; Thu, 12 Feb 2004 10:10:38 -0500 (EST) From: Bruce Momjian Message-Id: <200402121510.i1CFAcq18481@candle.pha.pa.us> Subject: Re: array_lower /array_prepend doubt In-Reply-To: <11796.1074712551@sss.pgh.pa.us> To: Tom Lane Date: Thu, 12 Feb 2004 10:10:38 -0500 (EST) Cc: Joe Conway , Rajesh Kumar Mallah , pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/114 X-Sequence-Number: 16805 Tom Lane wrote: > Joe Conway writes: > > We may need another extension to the array literal syntax in > > order to deal with this. I'll report back after I've had some time to > > study it. > > There already is support in array_in for specification of the array > dimensions (though it may be suffering bit rot for lack of use/testing). > I think the main thing needed is some thought about when array_out > should print dimensions; we don't want it doing so all the time, for > both clutter and backwards compatibility reasons. Maybe "whenever any > lower bound is not 1" would do; or maybe we want to invent a GUC switch > to control its behavior. Is this a TODO? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073