X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB46C329FD7 for ; Tue, 5 Oct 2004 14:27:12 +0100 (BST) 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 99328-09 for ; Tue, 5 Oct 2004 13:27:07 +0000 (GMT) Received: from fusion.bennyvision.com (fusion.bennyvision.com [216.161.119.28]) by svr1.postgresql.org (Postfix) with SMTP id 6F597329CFD for ; Tue, 5 Oct 2004 14:27:09 +0100 (BST) Received: (qmail 24338 invoked from network); 5 Oct 2004 13:27:07 -0000 Received: from localhost (HELO webmail.stinkweasel.net) (127.0.0.1) by fusion.bennyvision.com with SMTP; 5 Oct 2004 13:27:07 -0000 Received: from 63.227.74.41 (SquirrelMail authenticated user benny); by webmail.stinkweasel.net with HTTP; Tue, 5 Oct 2004 08:26:45 -0500 (CDT) Message-ID: <51832.63.227.74.41.1096982827.squirrel@63.227.74.41> In-Reply-To: <20041005070404.GA44500@winnie.fuhr.org> References: <64789.63.227.74.41.1096948602.squirrel@63.227.74.41> <20041005070404.GA44500@winnie.fuhr.org> Date: Tue, 5 Oct 2004 08:26:45 -0500 (CDT) Subject: Re: Stuffing six separate columns into a single array? From: "C. Bensend" To: pgsql-sql@postgresql.org User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal 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: 200410/28 X-Sequence-Number: 19131 > How does dns_ptr relate to other data? Depending on what you're > doing, other ways of organizing your tables might also make sense. These are actually DNS servers authoritive for a domain that is stored in a VARCHAR() in the same table. After sleeping on it, I think using an array is indeed not the right choice. I think splitting the nameservers off into their own table is probably smarter for what I want to do. Thanks, Michael, for the mental boot to the head. :) Benny -- "Even if a man chops off your hand with a sword, you still have two nice, sharp bones to stick in his eyes." -- .sig on Slashdot