Re: getting the ranks of items

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Randal L(dot) Schwartz" <merlyn(at)stonehenge(dot)com>
Cc: Matthew Terenzio <matt(at)jobsforge(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: getting the ranks of items
Date: 2005-05-04 01:55:11
Message-ID: 42782B7F.4020504@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Sincerely,

Joshua D. Drake

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2005-05-04 02:12:16 Re: getting the ranks of items
Previous Message Sean Davis 2005-05-04 01:46:17 Re: getting the ranks of items