Exact Numerics (Language Reference Guide)
Go Up to SQL Statement and Function Reference
All NUMERIC
and DECIMAL
data types are stored as exact numerics: 16, 32, or 64 bits, depending on the precision. NUMERIC
and DECIMAL
data types with precision greater than 9 are referred to as large exact numerics.
- If one operand is an approximate numeric, the result of any dyadic operation (addition, subtraction, multiplication, division) is DOUBLE PRECISION.
- Any value that can be stored in a DECIMAL(18,S) can also be specified as the default value for a column or a domain.