Random not so random - Mailing list pgsql-general

From Arnau Rebassa
Subject Random not so random
Date
Msg-id BAY15-F33XWzRPTNZSt00025523@hotmail.com
Whole thread Raw
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

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


pgsql-general by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: VACUUM FULL on 24/7 server
Next
From: ben f
Date:
Subject: sequence rename?