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