Re: LAST_INSERT_ID equivalent

Edmund Dengler wrote:
> Greetings all!
> 
> I believe
>    select currval('sequence_name');
> should satisfy your needs. Within a transaction it will stay the same.

Ed, thanks, this looks like what I was looking for --

however, I am concerned by your disclaimer.  Can you explain that a 
little bit?  I read it to mean "if you try to use this technique within 
a transaction where you are INSERTing a new record, it will not reflect 
the new record's ID".  So then in order to determine the new record's ID 
I would need to use

   SELECT CURRVAL('sequence_name') + 1;

within the transaction.


Thanks,

Erik