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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general