Random not so random

From: "Arnau Rebassa" <arebassa(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Random not so random
Date: 2004-10-01 16:29:52
Message-ID: BAY15-F33XWzRPTNZSt00025523@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

_________________________________________________________________
¿Cuánto vale tu auto? Tips para mantener tu carro. ¡De todo en MSN Latino
Autos! http://latino.msn.com/autos/

Browse pgsql-general by date

  From Date Subject
Next Message Arnau Rebassa 2004-10-01 16:42:33 Random not so random
Previous Message Thomas Kellerer 2004-10-01 16:19:59 Re: Free Unix-Like ODBC Driver Manager For Win32?