Retrieving serial or uid in same insert query

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

Browse pgsql-general by date

  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