Postgres Pro
Downloads
Home   >   mailing lists

Best way to return Random rows from a table with non-repeatability of rows - Mailing list pgsql-general

From Kiran
Subject Best way to return Random rows from a table with non-repeatability of rows
Date
Msg-id CAJfd1U582MsRXqhjt4JMvtTpd0p+f1FAXsRF9Y+zNuXiyZ45xw@mail.gmail.com
Whole thread Raw
Responses Re: Best way to return Random rows from a table with non-repeatability of rows  (Chris Mair <chris@1006.org>)
List pgsql-general
Tree view
Dear folks,

I have a table with thousands of rows ( currently 15 thousand but will grow very fast).
I need to return from the query rows which are random and non-repeating. 
 I know there is random() function, but would like to know from postgresql practitioners before embarking that path.
Please let me know what is best way to handle this type of queries.

regards
Kiran


pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: WHERE ... IN condition and multiple columns in subquery
Next
From: Kim Rose Carlsen
Date:
Subject: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other