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" <[email protected]> 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/
>
_______________________________________________
database-devel mailing list
[email protected]
http://www.haskell.org/mailman/listinfo/database-devel
