> > I recently had this problem. Values stored as real values. Had to check > > records in the database to see if any value had changed, and needed > > updating. Even though all values in my code were singles, I had bad > > rounding problems where (as an example) 0.1+2.2 did not equal 2.3 in the > > database. Aargh.
The distance between the IEEE745 representation of 0.1 + the IEEE754 representation of 2.2 is within 1 ULP of IEEE754 representation of 2.3 as is prescribed by the IEEE754 specifications. On this scale 1 ULP is 4.44089209850063e-16 which means the difference is 0.0000000000000004408920950063 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
