>>>>> "Harald" == Harald Fuchs <use_reply_to@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx> <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! ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
