Operators

The usual arithmetic operators are available.

SELECT 3+5;
=> 8

SELECT 3-5;
=> -2

Changes the sign of the argument

SELECT - 2;
=> -2

SELECT 3*5;
=> 15

SELECT 3/5;
=> 0.60

Division by zero returns NULL:

SELECT 102/(1-1);
=> NULL

SELECT 253 % 7;
=> 1