X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9364052997 for ; Thu, 21 Jul 2005 13:02:54 -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 93123-09 for ; Thu, 21 Jul 2005 16:02:44 +0000 (GMT) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id A38F052815 for ; Thu, 21 Jul 2005 13:02:30 -0300 (ADT) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.13.4/8.13.4) with ESMTP id j6LG2AuH011308; Thu, 21 Jul 2005 20:02:10 +0400 (MSD) Date: Thu, 21 Jul 2005 20:02:10 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Filipe Knoedt Cc: PG LIST Subject: Re: N-to-N implementation In-Reply-To: <010901c58e0a$37e50420$1300a8c0@brasilenergia> Message-ID: References: <010901c58e0a$37e50420$1300a8c0@brasilenergia> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.327 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200507/179 X-Sequence-Number: 18235 On Thu, 21 Jul 2005, Filipe Knoedt wrote: > Hi all, > > I'd like to set up a discussion (if necessary) about two different ways to implement N-to-N relationships: using a N-to-N intermediary table or, suppose an A and B tables situation, creating the primary key of the table B with the A.id plus a sequencer. > > I'm thinking on going the second way, but decided to ask the list if anybody sees any potencial problem in it, like for performance or anything. we use contrib/intarray to avoid joining > > Filipe Knoedt Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83