Re: Achieving ordered update - Mailing list pgsql-general

From Thom Brown
Subject Re: Achieving ordered update
Date
Msg-id bddc86151003250553n6de7096as65a3fad5cfbf5eba@mail.gmail.com
Whole thread Raw
In response to Achieving ordered update  (Allan Kamau <kamauallan@gmail.com>)
List pgsql-general
On 25 March 2010 12:02, Allan Kamau <kamauallan@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

pgsql-general by date:

Previous
From: Allan Kamau
Date:
Subject: Achieving ordered update
Next
From: Krzysztof Nienartowicz
Date:
Subject: pgfoundry registration