On Thu, 26 Apr 2001, Jie Liang wrote:
> > I've donne something like:
> >
> > prereg_iw=# select random(), nombre from asistente order by 1 limit 10;
> > random | nombre
> > ----------------------+---------------
> > 0.000214523170243261 | ALFONSO
> > 0.000478655100091666 | OSCAR
> > 0.000892118085591177 | JOSE LUIS
> > 0.000972398091560415 | IGNACIO
> > 0.00109919300354048 | NORBERTO
> > 0.00180558208460248 | SALVADOR
> > 0.00196880800741204 | ANDRES NOE
> > 0.00197171233686233 | SARA MICHELLE
> > 0.00226354412839913 | DAVID
> > 0.00233715307076329 | RODOLFO
> > (10 rows)
How totally obvious in retrospect, and how much better of a solution than
the ones I offered. D'oh!
Thanks for posting it to the list.
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington