Re: Achieving ordered update

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Allan Kamau <kamauallan(at)gmail(dot)com>
Cc: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Achieving ordered update
Date: 2010-03-25 12:53:02
Message-ID: bddc86151003250553n6de7096as65a3fad5cfbf5eba@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 25 March 2010 12:02, Allan Kamau <kamauallan(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-03-25 13:26:25 Re: [GENERAL] pgfoundry registration
Previous Message Krzysztof Nienartowicz 2010-03-25 12:05:45 pgfoundry registration