Mr. May,
For discussions of JDBC, please subscribe to the pgsql-interfaces
list. You will find many JDBC users on that list.
-Josh Berkus
P.S. PGSQL folks, is there any way we can clarify this on the web page?
The JDBC users seem to keep ending
Am I the only one who's nervous about these
two tables referencing each other like this?
I would have a concern that this is being
imposed, perhaps, by some external format
that the data arrives in, and that a
decently normalized design will have a
simple all-key table containing nothing
but seria
Josh and anyone interested,
I've slightly changed the function. C source of a standalone program is
available from
http://www.primechoice.com/hum/uspn.c
Comments welcome.
Thx
Ed
PS Lemme know if you need a function, callable from PGSQL
--
Well I tried to be meek
And I have tr
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
Hi,
I've been using the postgresql.Driver with JDBC for some time.
Initially, I was passing Statement objects through functions to each of the
Classes.
This was working beautifully.
I have since adapted my application to support MS SQL Server.
SQL Server doesn't allow a statement object to
>>> 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 |
> -
12 matches
Mail list logo
