X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id F12499FA4A8 for ; Tue, 13 Jun 2006 00:51:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 17621-05 for ; Tue, 13 Jun 2006 00:51:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31804.mail.mud.yahoo.com (web31804.mail.mud.yahoo.com [68.142.207.67]) by postgresql.org (Postfix) with SMTP id 2592B9FA10A for ; Tue, 13 Jun 2006 00:51:20 -0300 (ADT) Received: (qmail 15912 invoked by uid 60001); 13 Jun 2006 03:51:20 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=kSGLg44YyXTF406JJaCdbfpmLSeXDC9r0z5U0xhtrFiXQG5hflhzWraEhTk8dNzkdKkikWT4MsGb3Ec1bEGwUup40JkhXRLA/US2iIJq5+kPphc5rNtdBnUVSMA35ZJ6i9MeGuhYuUydQu19dDktHtw3Ki9YGqFNOVQgidDv/ms= ; Message-ID: <20060613035120.15910.qmail@web31804.mail.mud.yahoo.com> Received: from [68.235.218.116] by web31804.mail.mud.yahoo.com via HTTP; Mon, 12 Jun 2006 20:51:20 PDT Date: Mon, 12 Jun 2006 20:51:20 -0700 (PDT) From: Richard Broersma Jr Subject: Re: COPY to table with array columns (Longish) To: Rod Taylor , Aaron Bono Cc: phillips@weatherbeeta.com.au, pgsql-sql@postgresql.org In-Reply-To: <1150168731.73622.10.camel@home> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/129 X-Sequence-Number: 25365 > On Mon, 2006-06-12 at 21:58 -0500, Aaron Bono wrote: > > I agree with Tom. Personally I cannot think of a time I would use an > > array column over a child table. Maybe someone can enlighten me on > > when an array column would be a good choice. > > Arrays are a good choice when the data comes naturally segmented. > Also, for a case and point, some of the postgresql system tables use arrays. I suppose that these would be examples were the core develops felt arrays were a good fit. Regards, Richard Broersma Jr.