> >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