> On Nov 20, 2017, at 2:05 PM, Simon Slavin <[email protected]> wrote: > > INSERT INTO fruit VALUES ((1 + 2) / 2), 'banana') > > This gives you a value of 1.5, and puts the new entry in the right place.
This solution (which comes up every time this problem is discussed, it seems) is attractive but not very scaleable. All you have to do is add 60 records one at a time after record 1, and you’ll exceed the precision of double-precision floating point and get duplicate values that don’t have a stable sort order. —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
