[GENERAL] selecting random rows

[Joseph Shraibman]

Is there a way to get random rows besides ORDER BY random()?  The problem with ORDER BY 
random() is that is has to get all the rows from the table before the results are returned.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match