News for hackers. Stuff that matters.

A comment on 9999999999999999.0 – 9999999999999998.0. Parent comment

Re:9999999999999999.0 – 9999999999999998.0 by CamouflagedKiwi on Sunday January 06, 2019 @10:10AM (#18838675)
That seems okay until you need to track sub-penny accuracy somewhere, then you have a big problem.

Lots of applications don't need that, but a surprising amount do, so it's not a global solution.

[ Parent | on HN ]
Re:9999999999999999.0 – 9999999999999998.0 by hakfoo on Sunday January 06, 2019 @02:49PM (#18840171)
But there's still a minimum significant value which can be defined from the problem space. Do DECIMAL(16,8) or whatever.

In some situations, there may even be industry or legal standards as to what can be considered rounding noise.

[ Parent | on HN ]