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
