Random not so random - Mailing 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/