X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3199D3A4F19 for ; Sun, 28 Nov 2004 04:08:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30154-10 for ; Sun, 28 Nov 2004 04:08:23 +0000 (GMT) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 85C3D3A4F12 for ; Sun, 28 Nov 2004 04:08:21 +0000 (GMT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id iAS481507668; Sat, 27 Nov 2004 23:08:01 -0500 (EST) From: Bruce Momjian Message-Id: <200411280408.iAS481507668@candle.pha.pa.us> Subject: Re: Array function In-Reply-To: <20041101203847.GC11825@fetter.org> To: David Fetter Date: Sat, 27 Nov 2004 23:08:01 -0500 (EST) Cc: "Jim C. Nasby" , PostgreSQL Docs 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 hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/56 X-Sequence-Number: 2691 FYI, this discussion about adding a separate array section to the docs (which we already have, as Peter pointed out) is independent of the ARRAY() documentation addition I just put in the patch queue. --------------------------------------------------------------------------- David Fetter wrote: > On Mon, Nov 01, 2004 at 01:59:13PM -0600, Jim C. Nasby wrote: > > On Sun, Oct 31, 2004 at 04:36:14PM -0800, David Fetter wrote: > > > Folks, > > > > > > Here's a little addition to the array functions & operators > > > section of the manual. It adds a function array() to the list. > > > > > > Cheers, D > > > > BTW, it seems it would be useful to dedicate a chapter to array > > handling, since it's something that's not very common amongst > > databases. > > I guess it depends what you mean. Oracle has "subtables," and other > things have stuff like that. Also, it's in the SQL standard... > > Anyhow, where do you think it should go? > > Cheers, > D > -- > David Fetter david@fetter.org http://fetter.org/ > phone: +1 510 893 6100 mobile: +1 415 235 3778 > > Remember to vote! > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > -- 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