Re: Random tuple?

Brendan,

> Is there available a routine, intrinsic or otherwise, that allows for simple
> extraction of one(1) random tuple from a given table or query-result?
>
> (The specific application I had in mind was drawing a random product from a
> webstore's inventory to feature on a front or section web page).

SELECT tablea.*, random() as random_key
FROM tablea
ORDER BY random_key
LIMIT 1;

And you can modify the limit to select as many random rows as you want.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco