daydreamer daydreamer - 1 year ago 111
SQL Question

PostgreSQL: Which Datatype should be used for Currency?

Seems like

type is discouraged as described here

My application needs to store currency, which datatype shall I be using? Numeric, Money or FLOAT?

Answer Source

Numeric. Never use float for currency, and the money type is just left in for historical reasons as far as I can tell.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download