Skip to main content
The following table shows the mathematical operators that are available for the standard numeric types. Unless noted otherwise, all the operators return the same data type as their argument(s). The right arrow (⇒ ) is used to indicate the result. Notes:
  1. Division operator (/): Dividing integral_types returns the quotient of the integer division. To perform real numbers division, at least one of the operands should be non-integer. For example:
    SELECT 5/2;     Result: 2 SELECT 5/2::DECIMAL; SELECT 5.0/2; Result: 2.5000000000000000
  2. Exponentiation operator (^): By default, multiple uses of ^ are associated left to right. For example: SELECT 2 ^ (3 ^ 3); Result: 134,217,728 SELECT 2 ^ 3 ^ 3; Result: 512
  3. Modulo operator(%): Arguments can be either integral_type (INT, BIGINT, SMALLINT) or DECIMAL. It cannot be floating-point numbers (FLOAT or REAL).