> On Nov 30, 2016, at 5:53 PM, Keith Medcalf <kmedc...@dessus.com> wrote: > > Wattage problem based on incoherent understanding of how floating point > numbers are stored.
You may not be aware of this, Keith, but that comes off as really snarky and condescending. I feel I have a fairly coherent (if not domain-expert) understanding of FP, and it sounds like others here do too. And while I do not myself work with database schema involving money, I understand that the consensus among those who do is to _not_ store monetary values as floating-point, due to the roundoff error. Some people reject algorithms out-of-hand that accumulate even tiny amounts of roundoff error*. And of course the roundoff error increases as the size of the integer portion of the number increases. —Jens * just as some people reject UUID schemes with a tiny-but-nonzero chance of collisions, hmm? _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users