PostgreSQL randomly select

[Anon]

Is it possible to do random selects in PostgreSQL ? If so, may I ask how ? I've searched through the manual and its functions. There's nothing like rand() where MySQL has. So, I wonder how is it possible for me to do random selects with PHP & PostgreSQL ?

Thanks In Advance.

[Anon]

How big is the table you're selecting from? Can
you afford to do a <b>select count(*) from table</b>
first? If so, then you can just use php's rand() or
mt_rand() to give you a random number between
1 and the count, and use this in a limit 1 offset n
clause.