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

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. Em 12/07/2013 03:45, "Erik de Castro Lopo" <mle+hs@mega-nerd.com> escreveu:

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/