Computerphile
2 HN recommenders · recommended in 3 months, 2015–2023
9:16 · 2.5M views · Jan 22, 2014
Tom Scott explains for Computerphile how floating point numbers work, why moving the binary point is fast, and why it handles money badly.
Recommended as a simple, fun explanation of why floating point gives odd errors like 0.1 + 0.2.
3 comments from Hacker News
Recommended: Floating Point Numbers - Computerphile this video Tom Scott's fun and simple take on Floating Points is a good video explaining why such weird errors happen
Short answer, no decimal in binary and math is hard. :) Here's a couple handy videos explaining it: this video [LINK]
You should still not use MONEY in Postgres, even their own website says so [1]. I still wouldn't use floats/numerics/decimals to store currency either in any db generally, as said by others you're going to end up with inaccurate numbers [2]. Therefore using integers is in fact very good for this use-case, especially if you are in accounting or book-keeping! Source: I work for a Fintech company that processes millions of payments. [1] [LINK] [2] this video