Re: Antw: many-many mapping between unique tables - Mailing list pgsql-sql

From KuroiNeko
Subject Re: Antw: many-many mapping between unique tables
Date
Msg-id 39EB1B53.nail1L21P304T@ed.ed
Whole thread Raw
In response to Antw: many-many mapping between unique tables  ("Gerhard Dieringer" <DieringG@eba-haus.de>)
List pgsql-sql
> > 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 mildBut I spat like a woman And I sulked like a childI have lived behind
thewalls That have made me aloneStriven for peace Which I never have known
 
Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Antw: many-many mapping between unique tables
Next
From: Indraneel Majumdar
Date:
Subject: Re: Antw: many-many mapping between unique tables