Re: planet "top posters" section

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: planet "top posters" section
Дата
Msg-id c98cc5647fa35a15441adc03d079affc@biglumber.com
обсуждение исходный текст
Ответ на Re: planet "top posters" section  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: planet "top posters" section  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: planet "top posters" section
Следующее
От: Robert Haas
Дата:
Сообщение: Re: planet "top posters" section