Fixed-Point Types

Fixed-Point Types#

NUMERIC(precision, scale)
DECIMAL(precision, scale)
NUMERIC        -- without parameters
DECIMAL        -- without parameters

NUMERIC stores fixed-point decimal values with a maximum precision of 38 digits; without parameters it defaults to NUMERIC(38, 0). The (precision, scale) parameters are enforced on write: values are rounded (round-half-even) to the declared scale, and values whose digit count exceeds the declared precision are rejected.

Examples:

amount NUMERIC(18, 2)
rate   DECIMAL(9, 4)