From: | Jan de Visser <jdevisser(at)digitalfairway(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "Mavinakuli, Prasanna (STSD)" <prasanna(dot)b-m(at)hp(dot)com> |
Subject: | Re: Looking for help regarding getting the latest inserted sequence value. |
Date: | 2007-06-30 00:26:54 |
Message-ID: | 200706292026.54358.jdevisser@digitalfairway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday 28 June 2007 01:31:33 Mavinakuli, Prasanna (STSD) wrote:
> .And getting the max(id) from the table.
Instead of that, use select currval('sequence'). currval will
"
Return the value most recently obtained by nextval for this sequence in the
current session. (An error is reported if nextval has never been called for
this sequence in this session.) Notice that because this is returning a
session-local value, it gives a predictable answer whether or not other
sessions have executed nextval since the current session did.
"
(or so the docs tell me:
http://www.postgresql.org/docs/8.2/interactive/functions-sequence.html).
jan
--
--------------------------------------------------------------
Jan de Visser jdevisser(at)digitalfairway(dot)com
Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Andrej Ricnik-Bay | 2007-06-30 03:47:49 | Re: greatest/least semantics different between oracle and postgres |
Previous Message | Tom Lane | 2007-06-30 00:09:58 | Re: varchar(n) VS text |