Re: Antw: many-many mapping between unique tables

Поиск
Список
Период
Сортировка
От KuroiNeko
Тема Re: Antw: many-many mapping between unique tables
Дата
Msg-id 39EB1B53.nail1L21P304T@ed.ed
обсуждение исходный текст
Ответ на Antw: many-many mapping between unique tables  ("Gerhard Dieringer" <DieringG@eba-haus.de>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Antw: many-many mapping between unique tables
Следующее
От: Indraneel Majumdar
Дата:
Сообщение: Re: Antw: many-many mapping between unique tables