Unsupported versions: 6.3
Prev Chapter 8. Data Types Next

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 8-4. Postgres Numeric Types

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

The numeric should eventually replace the money type. It has a fully implemented syntax but currently (Postgres v6.3) support only a small range of precision and/or range values and cannot substitute for the money type.

Prev Home Next
Data Types Up Character Types