Databases · Junior · Question 10 of 75

Which column type is best for storing money amounts?

1text
2real or double precision
✓Correct answer: numeric (exact decimal) or an integer number of cents

Explanation

Floating-point types can't represent values like 0.1 exactly, so sums drift. numeric is exact; storing cents in bigint is also common.

Further reading

PostgreSQL: Numeric types ↗

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.