Random not so random - Mailing list pgsql-general

From Arnau Rebassa
Subject Random not so random
Date
Msg-id BAY15-F34sG06vdGg1f000253ee@hotmail.com
Whole thread Raw
Responses Re: Random not so random  (Jean-Luc Lachance <jllachan@sympatico.ca>)
Re: Random not so random  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Hi everybody,

I'm doing the following query:

   select * from messages order by random() limit 1;

in the table messages I have more than 200 messages and a lot of times, the
message retrieved is the same. Anybody knows how I could do a more "random"
random?

Thank you very much

--
Arnau

_________________________________________________________________
Consigue aquí las mejores y mas recientes ofertas de trabajo EE.UU.
http://latino.msn.com/empleos


pgsql-general by date:

Previous
From: Barry S
Date:
Subject: Re: Hardware recommendations
Next
From: sklassen@commandprompt.com
Date:
Subject: Re: Postgresql commands to display all functions and process/connections based on a database.