> 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
>
Vadim, what's a session?
-DEJ