Rory,
> I'd like to select 2 random rows from a table.
> At the moment I'm returning a couple of hundred rows into a perl hash
> and randomising it there, but it would be great if I could do it in the
> database call.
>
> Each row has an id number created using the SERIAL type.
This is actually quite easy:
SELECT *, RANDOM() as random_sort FROM the_table
ORDER BY random_sort LIMIT 2;
--
-Josh Berkus
