Noah Hart <[EMAIL PROTECTED]> wrote:
> I would expect that multiple calls to random always return different
> values, even if in the same line.
>
> The fact that we are aliasing random by a column name makes no
> difference to me.
What about this:
select name, RNDValue
from (
select name, random() as RNDValue from names
)
where RNDValue > 0;
Conceptually, the inner select produces a temporary table, and the outer
works on that table. Personally, I found it surprising that random() was
still called twice per row in this case.
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
