This page in other versions: Unsupported versions: 6.5

Monetary Type

The money type supports US-style currency with fixed decimal point representation. If Postgres is compiled with USE_LOCALE then the money type should use the monetary conventions defined for locale(7).

Table 3-4. Postgres Monetary Types

Monetary Type Storage Description Range
money 4 bytes Fixed-precision -21474836.48 to +21474836.47

numeric will replace the money type, and should be preferred.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group