| From: | Joshua Drake <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Bill <pg(at)dbginc(dot)com> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Steve Atkins <steve(at)blighty(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: MySQL LAST_INSERT_ID() to Postgres |
| Date: | 2008-08-28 22:44:53 |
| Message-ID: | 20080828154453.42a08d83@jd-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 28 Aug 2008 15:29:51 -0700
Bill <pg(at)dbginc(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-08-28 22:46:19 | Re: MySQL LAST_INSERT_ID() to Postgres |
| Previous Message | Christophe | 2008-08-28 22:32:32 | Re: indexes on functions and create or replace function |