>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