[GENERAL] Help pls with UPDATE

2005-10-31 Thread go KEY802207
Hi, pgsql-general. Tell me please, how to update a set of rows using order- something like : update my_table set counter1=nextval('my_seq') order by counter2 ; -- Regards, Igor mailto:[EMAIL PROTECTED] ---(end of

Re: [GENERAL] Help pls with UPDATE

2005-10-31 Thread Guy Rouillier
go KEY802207 wrote: Hi, pgsql-general. Tell me please, how to update a set of rows using order- something like : update my_table set counter1=nextval('my_seq') order by counter2 ; The way this is usually done is to issue a SELECT with an ORDER BY clause, then update the rows that

Re: [GENERAL] Help pls with UPDATE

2005-10-31 Thread Michael Glaesemann
On Nov 1, 2005, at 13:40 , Guy Rouillier wrote: go KEY802207 wrote: Hi, pgsql-general. Tell me please, how to update a set of rows using order- something like : update my_table set counter1=nextval('my_seq') order by counter2 ; The way this is usually done is to issue a SELECT with