Hi,
Thank you very much. Now I know to use serial and not oid. I hope I got
the correct message.
Thanks,
Indraneel
On Mon, 16 Oct 2000, Josh Berkus wrote:
> Please reference two things:
>
> 1. Look in the list archives for the last 4 weeks and you will read a
> long discussion on the risks/li
> > 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,
`direct
Mr. Majumdar,
>
> Sorry for splitting mails. Is there some way of using the oid of each
> row to do the mapping instead of creating two more columns of integers?
> The third table can then be like this:
>
> create table T3(
> T1 oid,
> T2 oid
> );
Please reference two
Sorry for splitting mails. Is there some way of using the oid of each
row to do the mapping instead of creating two more columns of integers?
The third table can then be like this:
create table T3(
T1 oid,
T2 oid
);
also how can I find out the oid of a particular row? a
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 bet
>>> Indraneel Majumdar <[EMAIL PROTECTED]> 16.10.2000 22.13 Uhr >>>
> Yeah you understand the problem perfectly. The third table will definitely
> contain unique entries if you take both x and y simultaneously. I wanted
> some way of mapping where I would not need to repeat individual values of
>
Yeah you understand the problem perfectly. The third table will definitely
contain unique entries if you take both x and y simultaneously. I wanted
some way of mapping where I would not need to repeat individual values of
x and y. I am not from a maths background and have absolutely no idea of
dat
>>> Indraneel Majumdar <[EMAIL PROTECTED]> 16.10.2000 20.11 Uhr >>>
> Hi,
>
> I am facing a problem in mapping between two tables containing unique
> entries
>
> T1T2
> _
> | x1 | | y1 |
> | x2 | | y2 |
> | x3 | | y3 |
> -
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 mor
