Alvaro Herrera wrote:
> Russ Brown escribió:
>> Masis, Alexander (US SSA) wrote:
>>> "SELECT CURRVAL(
>> Any reason why you can't just do this?
>> CREATE FUNCTION last_insert_id() RETURNS bigint AS $$
>> SELECT lastval();
>> $$ LANGUAGE SQL VOLATILE;
> If your table has a trigger that inserts into another table with its own
> sequence, you're screwed.
I assume you're equally screwed with MySQL LAST_INSERT_ID() in that case
- so it'd be bug compatible.
I know MSSQL had similar issues with the use of @@IDENTITY - which is
why they went down the ugly path of SCOPE_IDENTITY(). Why they didn't
just implement RETURNING, I have no idea...
In response to
pgsql-general by date
|Next:||From: J Welcomecert||Date: 2008-08-29 12:39:44|
|Subject: warning: libssl.so.4, needed by|
|Previous:||From: Laura Del Caño||Date: 2008-08-29 07:02:31|
|Subject: Re: pg_dump problem|