October 2001
Beginner to intermediate
400 pages
7h 45m
English
Numeric data types store a variety of number-related data. The 7.X series of releases has brought some changes to this area. Namely, PostgreSQL now uses a more descriptive naming convention for number-related data types (for example, BIGINT versus INT8).
Recently, some data types have become deprecated over the last few releases. For instance, use of the MONEY data type is no longer encouraged; instead, it is preferential to use the DECIMAL data type.
Holds a very large integer.
Large integer (approximately 1 × 10^18)
8 bytes
Versions of PostgreSQL before 7.1 might refer to this data type as INT8.
Holds a number of user-defined length ...
Read now
Unlock full access