Search Postgresql Archives

Best way to return Random rows from a table with non-repeatability of rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux