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

Reply via email to