X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BE08FDA3AD for ; Thu, 6 Oct 2005 08:52:39 -0300 (ADT) 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 31870-01 for ; Thu, 6 Oct 2005 11:52:34 +0000 (GMT) Received: from ms005msg.fastwebnet.it (ms005msg.fastwebnet.it [213.140.2.50]) by svr1.postgresql.org (Postfix) with ESMTP id BF09ADA3AA for ; Thu, 6 Oct 2005 08:52:34 -0300 (ADT) Received: from lyra (1.17.192.122) by ms005msg.fastwebnet.it (7.2.060.2) id 43224E39005FFEA0; Thu, 6 Oct 2005 13:52:32 +0200 Received: from localhost (lyra [127.0.0.1]) by lyra (Postfix) with ESMTP id AF970197368; Thu, 6 Oct 2005 13:52:45 +0200 (CEST) Received: from lyra ([127.0.0.1]) by localhost (lyra [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10474-02; Thu, 6 Oct 2005 13:52:43 +0200 (CEST) Received: by lyra (Postfix, from userid 1003) id 95A90197367; Thu, 6 Oct 2005 13:52:43 +0200 (CEST) Subject: Re: Noob question about types and lists From: xchris To: Richard Huxton Cc: pgsql-sql@postgresql.org In-Reply-To: <4345088E.4090001@archonet.com> References: <1128595206.27646.18.camel@lyra> <4345088E.4090001@archonet.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Thu, 06 Oct 2005 13:52:43 +0200 Message-Id: <1128599563.27646.35.camel@lyra> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 X-Virus-Scanned: by amavisd-new at lyra X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.682 required=5 tests=[AWL=-0.062, DNS_FROM_RFC_ABUSE=0.374, RCVD_ILLEGAL_IP=1.37] X-Spam-Level: * X-Archive-Number: 200510/51 X-Sequence-Number: 22904 On gio, 2005-10-06 at 12:20 +0100, Richard Huxton wrote: > From the manuals... > I didn't search very well.Sorry! > > However - I don't think you want to anyway. If you're going to use a > relational database, try a relational approach! Typically, you would do > something like [cut] I wanted to use a different approch because addresses don't make any sense for other tables and because they are typically few (3,4) and i wanted to avoid making a join for this task... however.. i will use your approch. Thank you for patience and suggestion! Regards Chris