Received: from sivka.carrier.kiev.ua (root@sivka.carrier.kiev.ua [193.193.193.101]) by hub.org (8.10.1/8.11.0) with ESMTP id e9GFUpW99243 for ; Mon, 16 Oct 2000 11:30:51 -0400 (EDT) (envelope-from evpopkov@carrier.kiev.ua) Received: from planka.carrier.kiev.ua (root@users.lucky.net [193.193.193.106]) by sivka.carrier.kiev.ua (8/Kilkenny_is_better) with ESMTP id SLV96824 for ; Mon, 16 Oct 2000 18:30:45 +0300 (EEST) (envelope-from evpopkov@carrier.kiev.ua) Received: from ed.ed (ln2-59.users.lucky.net [193.193.199.59]) by planka.carrier.kiev.ua (8) with ESMTP id SLV09919 for ; Mon, 16 Oct 2000 18:30:43 +0300 (EEST) (envelope-from evpopkov@carrier.kiev.ua) Received: (from root@localhost) by ed.ed (8.8.7/8.8.5) id PAA02060 for pgsql-sql@postgresql.org; Mon, 16 Oct 2000 15:14:27 GMT From: KuroiNeko Date: Mon, 16 Oct 2000 15:14:27 +0000 To: pgsql-sql@postgresql.org Subject: Re: Antw: many-many mapping between unique tables Message-ID: <39EB1B53.nail1L21P304T@ed.ed> References: User-Agent: nail 9.14 2000-06-26 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/148 X-Sequence-Number: 1810 > > I am facing a problem in mapping between two tables containing unique > > entries > > > Then you need a third table T12 with columns x and y, that contains one > row for each > mapping of a x(i) with a y(j). That's it. Normalize it. Relation T12 may also require the third field, `direction', to specify whether this is T1 -> T2 or T2 -> T1. In general, it'd be much better to re-design data layout. -- Well I tried to be meek And I have tried to be mild But I spat like a woman And I sulked like a child I have lived behind the walls That have made me alone Striven for peace Which I never have known Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)