Re: Randomize Result Set Order

Поиск
Список
Период
Сортировка
От merlyn@stonehenge.com (Randal L. Schwartz)
Тема Re: Randomize Result Set Order
Дата
Msg-id m1zo7gp7yk.fsf@halfdome.holdit.com
обсуждение исходный текст
Ответ на Randomize Result Set Order  (Ryan Mahoney <ryan@paymentalliance.net>)
Ответы Re: Randomize Result Set Order
Список pgsql-general
>>>>> "Ryan" == Ryan Mahoney <ryan@paymentalliance.net> writes:

Ryan> Is there an easy way to randomize the order that records get returned in?
Ryan> Don't imagine there is - but thought I'd ask  ;)

order by random()

I even threw it into my latest Linux Magazine column, expounding the
virtues of the official Database of RedHat.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <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!

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: PostGres is not using indices in select, I would like it to because it is too slow !
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Encoding passwords