Re: getting the ranks of items

>>>>> "Harald" == Harald Fuchs <use_reply_to@protecting.net> writes:

Harald> Using a temporary sequence for that would avoid naming conflicts.

>> P.S. I'm sure you can wrap it in plperl stored procedure :)

Well, yes.  I was (falsely?) recalling that there was a pure SQL way
to do this though.

And the point of doing it as part of the (sub)query is that I was then
going to do a further join and select on this.

Harald> Yes, prepending the ranking column in the application would be
Harald> more efficient.  I wonder whether Randall knows Perl? ;-)

If not, I'm sure I could dig up a couple of books to learn it. :)

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.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!