From: | merlyn(at)stonehenge(dot)com (Randal L(dot) Schwartz) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | getting the ranks of items |
Date: | 2005-05-04 00:30:06 |
Message-ID: | 86r7gnu92p.fsf@blue.stonehenge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm probably asking a FAQ, but a few google searches didn't seem
to point me in the right place.
Is there a simple way with PostgreSQL to assign relative ranks to the
result of a query ORDER BY? That is, I want to either have a view
that cheaply assigns the ranks, or be able to update a column with the
current ranks (yes, I know this latter version is more prone to
error).
I'm certain there's probably something I can do to laminate an array
value to a query result. Am I confused? (Yes!)
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn(at)stonehenge(dot)com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Terenzio | 2005-05-04 00:55:03 | Re: getting the ranks of items |
Previous Message | Greg Sabino Mullane | 2005-05-04 00:04:22 | Re: Deep integration of PostgreSQL with Apache |