Postgres Pro
Downloads
Home   >   mailing lists

Re: PQoidValue - get last ID of primary key after INSERT - small - Mailing list pgsql-interfaces

From Gregory Stark
Subject Re: PQoidValue - get last ID of primary key after INSERT - small
Date
Msg-id 87psf0xkr1.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: PQoidValue - get last ID of primary key after INSERT - small  (Georgi Kolev <geo_kolev@mail.ru>)
List pgsql-interfaces
Tree view 
Georgi Kolev <geo_kolev@mail.ru> writes:

> I agree that the solution INSERT...RETURNING is more general and flexible. But
> I think if we have such a solution as @@identity as in Sybase, PostgreSQL will
> be much more compatible and adoptable for migrations.

What characteristic does @@identity have that lastval() lacks? 


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com

pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: leaving out paramTypes parameter
Next
From: osxdeveloper@mac.com
Date:
Subject: Transactions and libpq