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 #
`************************************************************************/
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 |