Conventions for all the Mathematical Functions and Operators sections:

  • integral_type represents fixed full number data types (SMALLINT, INTEGER, and BIGINT).
  • numeric_type refers to all the available Numeric types.
  • DOUBLE represents approximate numeric data types (DOUBLE, FLOAT, REAL).
  • DECIMAL represents an exact numeric data type (NUMERIC).