Unsupported versions: 6.3
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the supported versions listed above instead.
PostgreSQL
Prev Chapter 8. Data Types Next

Numeric Types

Numeric types consist of two- and four-byte integers and four- and eight-byte floating point numbers.

Table 8-3. Postgres Numeric Types

Numeric Type Storage Description Range
int2 2 bytes Fixed-precision -32768 to +32767
int4 4 bytes Usual choice for fixed-precision -2147483648 to +2147483647
float4 4 bytes Variable-precision 7 decimal places
float8 8 bytes Variable-precision 14 decimal places

The exact numerics decimal and numeric have fully implemented syntax but currently (Postgres v6.3) support only a small range of precision and/or range values.


Prev Home Next
Data Types Up Monetary Type