Re: planet "top posters" section - Mailing list pgsql-www

From Greg Sabino Mullane
Subject Re: planet "top posters" section
Date
Msg-id c98cc5647fa35a15441adc03d079affc@biglumber.com
Whole thread Raw
In response to Re: planet "top posters" section  (Magnus Hagander <magnus@hagander.net>)
Responses Re: planet "top posters" section
List pgsql-www
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> Nope, we sort it by score only, which means the ones being listed on
> the toplist is in "pseudo random" order of however they happen to be
> on disk.

May I introduce you to the "ORDER BY random()" concept? :)

> But yes, it's rather easy to do with a window query. The big thing is
> that I'd need to upgrade the machine to 8.4 :-P

I would hope most everything we have is 8.4, in the name of 
eating our own dog food.

- -- 
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 201004221541
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkvQpogACgkQvJuQZxSWSsjU2gCdGnqIL3KHqe/BcDhcm/nb36n/
dT4An2gtFKJBXZC7XsZY7R+lu9QctPkR
=pTVP
-----END PGP SIGNATURE-----




pgsql-www by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: planet "top posters" section
Next
From: Robert Haas
Date:
Subject: Re: planet "top posters" section