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
__
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
__
Hi Greg,
What OS is this? Postgres is just using your OS's random()/srandom() calls.
On
some platforms these may be poorly implemented and not very random.
I'm using a debian linux as OS with a 2.4 kernel running on it.
Incidentally, are you reconnecting every time or is it that multiple calls
i