> Tthe problem with this is that this is not very random.
> If the uids 30000 to 39999 have been missing, but
> the uids are more or less contiguous apart from that,
> the uid 40000 would be 10000 times more likely to be selected
> than average.
There are some gaps but distribution of them is quite uniform. And results
seem to be random enuff for this particular purpose.
> Maybe using an OFFSET of (count(*) * random()) and a LIMIT 1
> could be practical.
Something like OFFSET (random() * 10) could be used for additional
randomness of course.
|\__/|
( oo ) Kari Lavikka - tuner@bdb.fi
__ooO( )Ooo_______ _____ ___ _ _ _ _ _ _ _
""