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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users