You can use arithmetic operators to perform calculations on values of data types that are supported by PolarDB. This topic describes the arithmetic operators that are supported by PolarDB for PostgreSQL(Compatible with Oracle).

The following table describes available arithmetic operators.

OperatorDescriptionExampleResult
+Addition.2 + 35
-Subtraction.2 - 3-1
*Multiplication.2 * 36
/Division. Integer division truncates the result.4 / 22
**Exponentiation.2 ** 38