Re: Selecting a random row - Mailing list pgsql-general

> 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_______ _____ ___ _ _  _   _    _      _                  _
      ""