Thread: RE: [GENERAL] getting the currval of a sequence

RE: [GENERAL] getting the currval of a sequence

From
"Jackson, DeJuan"
Date:
> 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