Regarding:
select cast(round(abs(random())/9223372036854775808) as int)
means I want sqlite to toss a virtual coin and return 0 or 1. It looks
like
a kludge but I could find neither a simpler nor clearer way of
expressing
this, can you?
Maybe:
select abs(random() % 2); -- random zero or one
or
select random() > 0; -- random zero or one
where the comment is the most important part. ;-)
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
