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.

Question... does the above query have to "look" at every row in tablea,
assign each a random number, sort it, and then return just one result?

If so, would it make more sense to setup a periodic process (via cron say)
to do extract 10-20 products into a featured_product table and query that?

Just thinking in terms of the amount of pounding the DB would take...

?

-philip