Re: Looking for help regarding getting the latest inserted sequence value.

[Jan de Visser <jdevisser(at)digitalfairway(dot)com>]

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!
--------------------------------------------------------------