Quoth "Black, Michael (IS)" <michael.bla...@ngc.com>, on 2011-03-04 21:55:01 +0000: > SQlite's random() is a pseudo-random (as are most all) so there is > no collision until you get the same value back at which point it > just repeats the whole sequence again.
Yes, it's a PRNG, but even if the total period is at least 2^64, that doesn't guarantee no repeated 64-bit values unless the output reflects the entire state, no? ISTR SQLite using (A)RC4. And that doesn't help between connections. ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users