Re: getting the ranks of items - Mailing list pgsql-general

From Mike Nolan
Subject Re: getting the ranks of items
Date
Msg-id 200505040212.j442CHOn029724@gw.tssi.com
Whole thread Raw
In response to Re: getting the ranks of items  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: getting the ranks of items
Next
From: Tom Lane
Date:
Subject: Re: Favorable Postgresql write up