PrevChapter 8. Data TypesNext

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 TypeStorageDescriptionRange
int22 bytesFixed-precision-32768 to +32767
int44 bytesUsual choice for fixed-precision-2147483648 to +2147483647
float44 bytesVariable-precision7 decimal places
float88 bytesVariable-precision14 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.

Data TypesUpMonetary Type