[ADMIN] Re: random rows

[J.H.M. Dassen (Ray)]

Jie Liang <[EMAIL PROTECTED]> wrote:
>e.g. what my selectee is a set of 1000 rows, I want randomly pickup 100 of
>1000.

Have you tried 
        SELECT * FROM selectee ORDER BY random() LIMIT 100;
?o

HTH,
Ray
-- 
<GRub[B]eR> JHM, jij bent echt nerd :))
<GRub[B]eR> maar wel een goeie :)
<GRub[B]eR> Soort van programmerende furby
        Gezien op #cistron


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl