>This thread is getting out of hand. Firstly there is no such binary >representation ( in this universe ) for a trivial decimal number such >as one tenth ( 0.10 ) and really folks should refer to the text book >recently published ( 2nd Edition actually ) where all this is covered >: > Handbook of Floating-Point Arithmetic > Authors: Muller, J.-M., Brunie, N., de Dinechin, F., > Jeannerod, C.-P., Joldes, M., Lefèvre, V., > Melquiond, G., Revol, N., Torres, S. > > This handbook is a definitive guide to the effective use of > modern floating-point arithmetic, which has considerably > evolved, from the frequently inconsistent floating-point number > systems of early computing to the recent IEEE 754-2008 standard.
https://doc.lagout.org/science/0_Computer%20Science/3_Theory/Handbook%20of%20Floating%20Point%20Arithmetic.pdf While it is true there is no exact representation of 1/10th in binary floating point, at double precision the epsilon is 1.3877787807814457e-17 which means that for all intents and purposes 1/10th is exact to 16.9 decimal places. Which is pretty damn good for a format that is only purported to be accurate to 15 decimal digits. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users