Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: 16 Aug 2006 20:34:58 -0400
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
- References:
- PQoidValue - get last ID of primary key after INSERT - small fix
- From: Georgi Kolev
- Re: PQoidValue - get last ID of primary key after INSERT - small fix
- From: Tom Lane
- Re: PQoidValue - get last ID of primary key after INSERT - small
- From: Georgi Kolev
- PQoidValue - get last ID of primary key after INSERT - small fix
- Prev by Date: Re: leaving out paramTypes parameter
- Next by Date: libpgsql and transaction behaviour
- Previous by thread: Re: PQoidValue - get last ID of primary key after INSERT - small
- Next by thread: leaving out paramTypes parameter
- Indexes: