Unsupported versions: 6.3
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