Re: PQoidValue - get last ID of primary key after INSERT - small

From: Gregory Stark <gsstark(at)mit(dot)edu>
To: Georgi Kolev <geo_kolev(at)mail(dot)ru>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: PQoidValue - get last ID of primary key after INSERT - small
Date: 2006-08-17 00:34:58
Message-ID: 87psf0xkr1.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Georgi Kolev <geo_kolev(at)mail(dot)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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ralf Hasemann 2006-08-21 21:11:11 libpgsql and transaction behaviour
Previous Message Tom Lane 2006-08-14 15:23:22 Re: leaving out paramTypes parameter