From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
---|---|
To: | pgsql-www(at)postgresql(dot)org |
Subject: | Re: planet "top posters" section |
Date: | 2010-04-22 19:42:15 |
Message-ID: | c98cc5647fa35a15441adc03d079affc@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)turnstep(dot)com
PGP Key: 0x14964AC8 201004221541
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAkvQpogACgkQvJuQZxSWSsjU2gCdGnqIL3KHqe/BcDhcm/nb36n/
dT4An2gtFKJBXZC7XsZY7R+lu9QctPkR
=pTVP
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-04-22 19:43:54 | Re: planet "top posters" section |
Previous Message | Magnus Hagander | 2010-04-22 19:29:54 | Re: planet "top posters" section |