3 ms·
The money one is a bit worrying, at least if "numerical" includes floating point types. It's almost never a good idea to use these for monetary values. If you
by chopin 8y ago
The money one is a bit worrying, at least if "numerical" includes floating point types. It's almost never a good idea to use these for monetary values.
If you are going to have different currencies I almost always would go for integer types (I don't understand the "rarely" advice here) as the fraction may vary greatly for different currencies. It's better to derive the fractional from the currency.
- colanderman 8y ago`numeric` is a decimal type with an optional fixed-precision mode, so it works fine with decimal currencies.