The precision of a data type is the number of digits
that the data type stores. The scale is the number of digits
to the right of the decimal separator.
The following table summarizes the exact numeric data
types available.
Data Type
Description
DEC(p,s)
Synonym for DECIMAL(p,s)
DECIMAL(p,s)
Stores fixed-point decimal values of real numbers,
with up to 30 significant digits in the fractional part, or up to
32 significant digits to the left of the decimal point.
INT
Synonym for INTEGER
INTEGER
Stores a 4-byte integer value. These values can
be in the range from -(231-1) to 231-1 (from
-2,147,483,647 to 2,147,483,647).
BIGINT and INT8
Stores an 8-byte integer value. These values can
be in the range from -(263-1) to 263-1 (the
range -9,223,372,036,854,775,807 to 9,223,372,036,854,775,807). BIGINT
has storage and processing advantages over INT8.
MONEY(p,s)
Stores fixed-point currency values. These values
have same internal data format as a fixed-point DECIMAL(p,s) value.
NUMERIC(p,s)
ANSI-compliant synonym for DECIMAL(p,s)
SERIAL
Stores a 4-byte positive integer that the database
server generates. Values can range from 1 to 231-1 (that
is, from 1 to 2,147,483,647).
BIGSERIAL and SERIAL8
Stores an 8-byte positive integer value that the
database server generates. Values can range from 1 to 263-1
(that is, from 1 to 9,223,372,036,854,775,807). BIGSERIAL has
storage and processing advantages over SERIAL8.
SMALLINT
Stores a 2-byte integer value. These values can
be in the range from -(215-1) to 215-1 (that
is, from -32,767 to 32,767).
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.