From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Insert Question |
Date: | 2006-11-02 21:46:13 |
Message-ID: | 460264.21342.qm@web31804.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> 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.
Regards,
Richard Broersma Jr.
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2006-11-02 23:37:30 | Re: Insert Question |
Previous Message | operationsengineer1 | 2006-11-02 21:20:46 | Re: Insert Question |