Re: [GENERAL] Achieving ordered update

2010-03-28 Thread Bopolissimus Platypus Jr
On Fri, Mar 26, 2010 at 1:02 AM, Allan Kamau wrote: > A classic problem. I would like to assign integer values (from a > sequence) to records in a table based on the order (of contents) of > other field(s) in the same table. Do you have a simple example? (create table, insert some data, then sho

Re: [GENERAL] Achieving ordered update

2010-03-25 Thread Thom Brown
On 25 March 2010 12:02, Allan Kamau wrote: > Hi, > A classic problem. I would like to assign integer values (from a > sequence) to records in a table based on the order (of contents) of > other field(s) in the same table. > I come across the solution before but I simply may not recall and a > sea