Re: getting the ranks of items

Поиск
Список
Период
Сортировка
От Mike Nolan
Тема Re: getting the ranks of items
Дата
Msg-id 200505040212.j442CHOn029724@gw.tssi.com
обсуждение исходный текст
Ответ на Re: getting the ranks of items  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
> > If I order a query by ascending age, the youngest person gets
> > rank 1, the second youngest gets rank 2, the third youngest gets rank 3,
> > and if the fourth and fifth tie, they both get 4, and the next one gets 6.
> >
> > You know, rank? :)
>
> You could use a plPerl function.

To do it with ties, you'd need some way of passing the function the ranking
criteria with persistence between calls, which might have some startup issues.

Wouldn't that also cause problems with multiple users calling the function
simultaneously?
--
Mike Nolan

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: getting the ranks of items
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Favorable Postgresql write up