Numeric type overview
Numeric types include the following types, which provide storage of varying sizes:
Integer numerics
SMALLINT
(2 bytes)
INTEGER
(4 bytes)
BIGINT
(8 bytes)
Approximate or floating-point numerics
REAL
(4 bytes)
DOUBLE PRECISION
(8 bytes)
FLOAT
(an alias for
DOUBLE PRECISION
or
REAL
)
Exact numeric
DECIMAL
(storage based on precision)
NUMERIC
(an alias for
DECIMAL
)
Parent topic:
Numeric types
Related reference
Numeric type promotion in expressions
Storing values of one numeric data type in columns of another numeric data type
Scale for decimal arithmetic
Scripting on this page tracks web page traffic, but does not change the content in any way.