Re: Antw: many-many mapping between unique tables

From: Indraneel Majumdar <indraneel(at)www(dot)cdfd(dot)org(dot)in>
To: Gerhard Dieringer <DieringG(at)eba-haus(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Antw: many-many mapping between unique tables
Date: 2000-10-16 21:39:53
Message-ID: Pine.SGI.3.96.1001016143854.121309D-100000@www.cdfd.org.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)123india(dot)com #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`************************************************************************/

Browse pgsql-sql by date

  From Date Subject
Next Message Indraneel Majumdar 2000-10-16 21:54:47 Re: Antw: many-many mapping between unique tables
Previous Message Indraneel Majumdar 2000-10-16 20:13:56 Re: Antw: many-many mapping between unique tables