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)