pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gerhard Dieringer <DieringG@eba-haus.de>
To: indraneel@www.cdfd.org.in
Cc: pgsql-sql@postgresql.org
Subject: Antw: many-many mapping between unique tables
Date: Mon, 16 Oct 2000 08:57:52 +0200
Message-ID: <s9eac329.061@kopo001> (raw)

>>> Indraneel Majumdar <indraneel@www.cdfd.org.in> 16.10.2000  20.11 Uhr >>>
> Hi,
>
> I am facing a problem in mapping between two tables containing unique
> entries
>
> T1		T2
> _________	________
> |  x1	|	|  y1	|
> |  x2	|	|  y2	|
> |  x3	|	|  y3	|
> ---------	---------
>
> x(i) points to 1 or more entries in T2. y(i) points to one or more entries
> in T1. How do I store this mapping? I'd cannot use an array due to size
> restrictions and inability to extract data easily for furthur processing.
> 
> I don't want to put everything into a single table and repeat values in
> the 2nd column since these are really huge tables and I cannot increase
> overhead by increasing data redundancy.
> 
> Is there some way to do something about this?
>
> \Indraneel
> 
> /************************************************************************.
> # 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                                              #
> `************************************************************************/

I'm not sure if I understand your question. Is it right, that the x(i) are different values
of an column x in table T1 and the y(i) are different values of an column y in table T2?
And you want to have a n:m relation between the two tables?
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).

I hope this helps.


Gerhard








view thread (8+ messages)  latest in thread

Message-ID: <s9eac329.061@kopo001>
Permalink:  ../s9eac329.061@kopo001/
Also on:    postgresql.org/message-id/s9eac329.061@kopo001

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: DieringG@eba-haus.de, indraneel@www.cdfd.org.in
  Subject: Re: many-many mapping between unique tables
  In-Reply-To: <s9eac329.061@kopo001>
  References: <s9eac329.061@kopo001>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox