Re: limit, offset and random

[Øystein Grøvlen]

unludo wrote:

OK thanks a lot for your answers.

Regarding the 'ORDER BY RANDOM()', you also plan to have something similar?

ORDER BY RANDOM() already works for me. Example:

ij> select i from t where i < 5;
I
-----------
1
2
3
4

4 rows selected
ij> select i from t where i < 5 order by random();
I
-----------
1
2
4
3

4 rows selected
ij>


--
Øystein