Re: MySQL LAST_INSERT_ID() to Postgres - Mailing list pgsql-general

From Joshua Drake
Subject Re: MySQL LAST_INSERT_ID() to Postgres
Date
Msg-id 20080828154453.42a08d83@jd-laptop
Whole thread Raw
In response to Re: MySQL LAST_INSERT_ID() to Postgres  (Bill <pg@dbginc.com>)
List pgsql-general
On Thu, 28 Aug 2008 15:29:51 -0700
Bill <pg@dbginc.com> wrote:

> The PostgresSQL 8.3 help file clearly shows that lastval() does not
> take a sequence as a parameter and the description i is "Return the
> value most recently returned by |nextval| in the current session.
> This function is identical to |currval|, except that instead of
> taking the sequence name as an argument it fetches the value of the
> last sequence that |nextval| was used on in the current session. It
> is an error to call |lastval| if |nextval| has not yet been called in
> the current session." Is the help incorrect?

No.

Joshua D. Drake

>
> Bill


--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate



pgsql-general by date:

Previous
From: Christophe
Date:
Subject: Re: indexes on functions and create or replace function
Next
From: "Scott Marlowe"
Date:
Subject: Re: MySQL LAST_INSERT_ID() to Postgres