Floating Point Numbers - Computerphile

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

Short answer, no decimal in binary and math is hard. :) Here's a couple handy videos explaining it: ▶ this video link

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