> > 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
> > 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
> > 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
> 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.
In response to
pgsql-novice by date
|Next:||From: ketema||Date: 2006-11-04 15:24:02|
|Subject: Select permissions on system tables|
|Previous:||From: Richard Broersma Jr||Date: 2006-11-02 21:46:13|
|Subject: Re: Insert Question|