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)