On 08-12-17 23:34, Scott Doctor wrote: > > Is it possible that the first call to random is cached and the cached > value is being returned in subsequent calls? > > ------------------------- > Scott Doctor > sc...@scottdoctor.com > ------------------------- >
The easiest way to get this behaviour is to store the random value in a temp table, than you can use it as long as you like. sqlite> create temp table rnd (i integer); sqlite> select * from rnd; sqlite> insert into rnd values (random()); sqlite> select * from rnd; 7337803792641969525 sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
