[database-devel] Esquleto : 'ORDER BY random()'?

Erik de Castro Lopo mle+hs at mega-nerd.com
Fri Jul 12 08:45:46 CEST 2013


Hi all (and specifically Felipe),

I'm wonder who to implement the following SQL in Esqueleto:

    SELECT * FROM table WHERE field = X ORDER BY RANDOM() LIMIT N

I noticed that there is a random_ function and I figured out how to
use it by reading the tests, but it doesn't seem to be useful in
the above context.

Clues? Maybe Esqueleto needs an 'orderByRandom'.

Cheers,
Erik
-- 
----------------------------------------------------------------------
Erik de Castro Lopo
http://www.mega-nerd.com/



More information about the database-devel mailing list