Re: Insert Question

> > create sequence tmp_seq start with 42000005;
> >
> > update products set document_number =
> > nextval('tmp_seq')
> > where ocument_number is null;
> >
> > i had to do it this way because i actually had a
> few
> > entries in the db already.  it did work just fine,
> > though.
>
> In this case you could:
>
> create sequence temp_seq start with (select
> max(document_number) from products);
>
>
> >
> > i learned to use...
> >
> > drop sequence tmp_seq;
> >
> > in order to reuse the sequence as i was playing
> around
> > with functionality.  otherwise, it would return an
> > error b/c the sequence already existed.
>
> if you want to use the same sequence over again you
> could:
>
> select set_val('temp_seq', select
> max(document_number) from products));
> and then do your update.
>
> you will not need to drop your sequence this way.

Richard, good stuff.  thanks!



__________________________________________________________________________________________
Check out the New Yahoo! Mail - Fire up a more powerful email and get things done faster.
(http://advision.webevents.yahoo.com/mailbeta)