Jackson, DeJuan wrote:
>
> I think you should just go with what Vadim suggested and use:
> select currval('my_sequence');
> This will be the same within a transaction, even if there is another
^^^^^^^^^^^
session
> transaction using the same sequence.
> But (if memory servers), you have to have had select a nextval from that
> same sequence within the transaction.
^^^^^^^^^^^
session!
This is from create_sequence manual:
"...Function currval ('sequence_name') may be used
to determine number returned by last call to nextval for
specified sequence in current session."
Vadim