On Mon, 17 Dec 2018 17:35:54 +0000 Simon Slavin <slav...@bigfraud.org> wrote:
> On 17 Dec 2018, at 5:16pm, James K. Lowden <jklow...@schemamania.org> > wrote: > > > IEEE > > double-precision floating point is accurate to within 15 decimal > > digits. > > First, the problem is not storage it's calculation. > > Second, the thread was started because a floating point calculation > in SQLite, exactly as it is run today, led to the following value: > > 211496.25999999992 > > which is typical of such problems. What problem? Rounded to the number of significant digits -- 2 decimal places in the input -- the number is correct. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users