This page in other versions: Unsupported versions: 6.3
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

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

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