| The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference
by The PostgreSQL Global Development Group Paperback (6"x9"), 454 pages ISBN 9781906966041 RRP £14.95 ($19.95) Sales of this book support the PostgreSQL project! Get a printed copy>>> |
6.1 Numeric Types
Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals. Table 6-2 lists the available types.
Table 6-2: Numeric Types
| Name | Storage Size | Description | Range
|
smallint | 2 bytes | small-range integer | -32768 to +32767
|
integer | 4 bytes | typical choice for integer | -2147483648 to +2147483647
|
bigint | 8 bytes | large-range integer | -9223372036854775808 to 9223372036854775807
|
decimal | variable | user-specified precision, exact | no limit
|
numeric | variable | user-specified precision, exact | no limit
|
real | 4 bytes | variable-precision, inexact | 6 decimal digits precision
|
double precision | 8 bytes | variable-precision, inexact | 15 decimal digits precision
|
serial | 4 bytes | autoincrementing integer | 1 to 2147483647
|
bigserial | 8 bytes | large autoincrementing integer | 1 to 9223372036854775807 |
The syntax of constants for the numeric types is described in section 2.1.2 Constants. The numeric types have a full set of corresponding arithmetic operators and functions. Refer to section 7 Functions and Operators for more information. The following sections describe the types in detail.
| ISBN 9781906966041 | The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference | See the print edition |