RE: [GENERAL] getting the currval of a sequence - Mailing list pgsql-general

From Jackson, DeJuan
Subject RE: [GENERAL] getting the currval of a sequence
Date
Msg-id F10BB1FAF801D111829B0060971D839F399523@cpsmail
Whole thread Raw
List pgsql-general
> >On Fri, 14 Aug 1998, Fran Fabrizio wrote:
> >
> > If you've recently done an insert and want to know what the value
> >was, you can do this:
> >
> > select last_value from mysequence;
>
> Alternatively, you can get your key from the sequence before you
> insert, and
> override the default value of the key (they will be the same only now
> you
> explicitly got it).  Now that you know what the key value use, after
> you
> insert it you can do anything you want to with it.  To do this just
> do:
>
>    select nextval ('sequencename');
>
> ...james
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
transaction using the same sequence.
But (if memory servers), you have to have had select a nextval from that
same sequence within the transaction.

Hope this clears things up.
        -DEJ


pgsql-general by date:

Previous
From: "윤영철"
Date:
Subject: ...
Next
From: James Olin Oden
Date:
Subject: Re: [GENERAL] getting the currval of a sequence