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-O.
The following table describes available arithmetic operators.
Operator | Description | Example | Result |
---|---|---|---|
+ | Addition. | 2 + 3 | 5 |
- | Subtraction. | 2 - 3 | -1 |
* | Multiplication. | 2 * 3 | 6 |
/ | Division. Integer division truncates the result. | 4 / 2 | 2 |
** | Exponentiation. | 2 ** 3 | 8 |