| PostgreSQL | ||
|---|---|---|
| Prev | Chapter 8. Data Types | Next |
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 |