From: | "Esa Pikkarainen" <epikkara(at)ktk(dot)oulu(dot)fi> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Retrieving serial or uid in same insert query |
Date: | 2000-12-14 10:04:31 |
Message-ID: | 29FD8546FBD@ktk.oulu.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
How could I get the value of the Serial column or the UID of the row
that I just inserted. I should get it within one and the same query
with which I insert that row.
I know this is considered in FAQ but it does not solve the problem.
According to it I should make two queries: one for insert and one for
serial value.
I use iHTML PRO edition to handle Postgreql database. This means that
I can give only one query to the dbserver at a time. And asking
currval(sequence) in a separate ODBC connection is not safe at all.
So, is there any way to get Serial value or UID value within the same
query which inserts that new record???
Thanks
Esa Pikkarainen
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Ian Capon Fiel | 2000-12-14 10:05:40 | Re: PostgreSQL for windows 98, 2000, NT |
Previous Message | Chris Ian Capon Fiel | 2000-12-14 09:59:48 | Re: PostgreSQL v.7.0.2 for Windows 98,2000,NT |