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

From Indraneel Majumdar
Subject Re: Antw: many-many mapping between unique tables
Date
Msg-id Pine.SGI.3.96.1001016143854.121309D-100000@www.cdfd.org.in
Whole thread Raw
In response to Antw: many-many mapping between unique tables  ("Gerhard Dieringer" <DieringG@eba-haus.de>)
List pgsql-sql
Thanks, I too came to the same conclusion (due to lack of
persistence/patience).

Thanks,
Indraneel

On Mon, 16 Oct 2000, Gerhard Dieringer wrote:

> I don't know what type of data your columns x and y contain. If they are,
> for example, of type text and contain long strings, then it would be better
> to add an integer id column in each tables T1 and T2: x_id and y_id and
> use these ids in the table T12.
> 
> Then you only have to repeat the (short) numeric vales in T12. But I think there 
> is no way to totaly avoid any repetition.
> 
> --------------
> Gerhard
> 

/************************************************************************.
# Indraneel Majumdar                  ¡  E-mail: indraneel@123india.com  #
# Bioinformatics Unit (EMBNET node),  ¡  URL: http://scorpius.iwarp.com  #
# Centre for DNA Fingerprinting and Diagnostics,                         #
# Hyderabad, India - 500076                                              #
`************************************************************************/



pgsql-sql by date:

Previous
From: Craig May
Date:
Subject: JDBC Performance
Next
From: Indraneel Majumdar
Date:
Subject: Re: Antw: many-many mapping between unique tables