randomized order in select?

Поиск
Список
Период
Сортировка
От Enver ALTIN
Тема randomized order in select?
Дата
Msg-id 1078937297.29628.12.camel@enver.office.frontsite.com.tr
обсуждение исходный текст
Ответы Re: randomized order in select?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: randomized order in select?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-sql
Hi,

I have got a simple table like this:
       create table tips (           id integer primary key unique,           tiptext text       );

and, I've got a website where I'm willing to show these tips in a random
order. Each visitor will get a randomly selected tip. So for now, I have
to do 2 queries:
select id from tips

collect an ID list, choose one randomly and retrieve it. I wish I could
do something like:
select tiptext from tips order by random limit 1

in PostgreSQL.
-- __________
|          |
|          |  Enver ALTIN (a.k.a. skyblue)
|          |  Software developer, IT consultant
|    FRONT |
|==========|  FrontSITE Bilgi Teknolojisi A.Ş.
|_____SITE_|  http://www.frontsite.com.tr/

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

Предыдущее
От: "David"
Дата:
Сообщение: Changing primary keys
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: randomized order in select?