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