I'm on my phone and didn't test it, but can't you use
orderBy [asc random_]
? On your SQL the ASC is implicit.
Cheers, =]
--
Felipe.
Enviado do meu Nexus 4.
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/