Hacker News new | ask | show | jobs
by mercxry 970 days ago
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] https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use... [2] https://www.youtube.com/watch?v=PZRI1IfStY0