Re: planet "top posters" section

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-----

In response to

Responses

Browse pgsql-www by date

  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