On 25 March 2010 12:02, Allan Kamau <kamaual...@gmail.com> 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 > search returns no clues. Please point me to a resource with this > solution. > > Allan. > > - > Rank and a window function?
http://www.postgresql.org/docs/8.4/static/functions-window.html http://www.postgresql.org/docs/8.4/static/tutorial-window.html Thom
