Re: Achieving ordered update

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Achieving ordered update
Дата
Msg-id bddc86151003250553n6de7096as65a3fad5cfbf5eba@mail.gmail.com
обсуждение исходный текст
Ответ на Achieving ordered update  (Allan Kamau <kamauallan@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Allan Kamau
Дата:
Сообщение: Achieving ordered update
Следующее
От: Krzysztof Nienartowicz
Дата:
Сообщение: pgfoundry registration