Search Postgresql Archives

Re: getting the ranks of items

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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





---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux