Mathematical | Description | Example | Available in Oxla |
---|---|---|---|
ABS | Returns the absolute value of a number. | SELECT ABS(-11); | Available |
CEIL | Returns the value after rounding up any positive or negative value to the nearest largest integer. | SELECT CEIL(53.7); | Available |
FLOOR | Returns the value after rounding up any positive or negative decimal value as smaller than the argument. | SELECT FLOOR(53.6); | Available |
LN | Returns the natural logarithm of a given number. | SELECT LN(3); | Available |
RANDOM | Returns the random value between 0 and 1. | SELECT RANDOM(); | Available |
SQRT | Returns the square root of a given positive number. | SELECT SQRT(225); | Available |
Trigonometric | Description | Example | Available in Oxla |
---|---|---|---|
SIN | Returns the sine of the specified radian. | SELECT sin(0.2); | Available |
Operator | Description | Example | Result | Available in Oxla |
---|---|---|---|---|
+ | Addition | SELECT 5 + 8; | 13 | Available |
- | Subtraction | SELECT 2 - 3; | \-1 | Available |
- | Negation | SELECT -4; | \-4 | Available |
SELECT -(-4); | 4 | Available | ||
SELECT 5+(-2); | 3 | Available | ||
SELECT 5-(-2); | 7 | Available | ||
* | Multiplication | SELECT 3 * 3; | 9 | Available |
/ | Division | SELECT 10 / 2; | 5 | Available |
% | Modulo | SELECT 20 % 3; | 2 | Available |
& | Bitwise AND | SELECT 91 & 15; | 11 | Available |
# | Bitwise XOR | SELECT 17 # 5; | 20 | Available |
=
)Functions | Input | Output - Oxla | Output - PostgreSQL |
---|---|---|---|
LN | LN(0) | Infinity | ERROR: cannot take the logarithm of zero |
LN(0.0) | Infinity | ERROR: cannot take the logarithm of zero | |
LOG10 | LOG10(-1) | NaN | ERROR: cannot take logarithm of a negative number |
SQRT | SQRT(-1) | input is out of range | ERROR: cannot take the square root of a negative number |
SIN | SELECT sin(pi()/2); | unknown function pi | working as expected |