Differences Between Oxla vs. PostgreSQL

13min

1. Functionsa) MathematicalA mathematical function operates on input values provided as arguments and returns a numeric value as the operation's output.
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
b) TrigonometricTrigonometric
Description
Example
Available in Oxla
SIN
Returns the sine of the specified radian.
SELECT sin(0.2);
Available
2. OperatorsBelow is a list of math operators available in PostgreSQL:
Operators
Description
Example
Result
Available in Oxla
Note
+
Addition
SELECT 5+8;
SELECT 5 + 8;
SELECT 5+ 8;
SELECT 5 +8;
 f  
----
 13
Available
﻿
-
Subtraction
SELECT 2 - 3;
SELECT 2+-3;
 f  
----
 -1
Available
﻿
-
Negation
SELECT -4;
 f  
----
 -4
Available
﻿
﻿
﻿
SELECT -(-4);
 f  
----
 4
Available
﻿
﻿
﻿
SELECT 5+(-2);
 f  
----
 3
Available
﻿
﻿
﻿
SELECT 5-(-2);
 f 
----
 7
Available
﻿
*
Multiplication
SELECT 3*3;
SELECT 3 + 3;
SELECT 3+ 3;
SELECT 3 +3;
 f  
----
 9
Available
﻿
/
Division 
SELECT 10/2;
SELECT 10 / 2;
SELECT 10/ 2;
SELECT 10 /2;
 f  
----
 5
Available
﻿
%
Modulo
SELECT 20%3;
SELECT 20 % 3;
SELECT 20% 3;
SELECT 20 %3;
 f  
----
 2
Available
﻿
&
Bitwise AND
91 & 15
 f  
----
 91
Available
the result is different from PostgreSQL
#
Bitwise XOR
17 # 5
 f  
----
 17
Available
the result is different from PostgreSQL
3. Behaviors Differencea) Output HeaderMissing function name in output header, PostgreSQL shows the function name, like in this example:
Pgsql
|
SELECT COS(0),LN(1);
SELECT COS(0),LN(1);
﻿
Pgsql
|
cos  | ln 
-----+-----
 1   | 0
cos  | ln 
-----+-----
 1   | 0
﻿
Oxla does not show the function name, like in this example:
Pgsql
|
SELECT COS(0),LN(1);
SELECT COS(0),LN(1);
﻿
Pgsql
|
 f | f_1 
---+-----
 1 | 0
 f | f_1 
---+-----
 1 | 0
﻿
b) WhitespaceDifferent behavior of mathematical operators when white space is used. 
For example: Oxla can calculate expressions '2 - 3' or ‘2- 3’, but ‘2 -3’ or ‘2-3’ reports syntax errors. For other operators work in all cases.  
c) ABS OutputDifferences are also found in the ABS function, where there are differences in decimal results. 
For example: 
The example below will return the absolute value of -1.0
Pgsql
|
SELECT ABS(-1.0);
SELECT ABS(-1.0);
﻿
It returns 1 in Oxla, while in PostgreSQL, it produces 1.0
4. Errors DifferenceFunctions
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
SQRT
SQRT(-1)
NaN
ERROR: cannot take the square root of a negative number
RANDOM
SELECT floor(random()*(10-1+1))+1;
ERROR: syntax error, unexpected INTVAL
working as expected
SIN
SELECT sin(pi()/2);
unknown function pi
working as expected
/
1/0
error division(s) by zero
error division(s) by zero
﻿
1/0.0
Infinity
error division(s) by zero
﻿
0/0.0
NaN
error division(s) by zero
﻿

Updated 11 May 2023

Did this page help you?

Yes

Error Handling

Docs powered by archbee

TABLE OF CONTENTS

3. Behaviors Difference

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
SQRT	SQRT(-1)	NaN	ERROR: cannot take the square root of a negative number
RANDOM	SELECT floor(random()*(10-1+1))+1;	ERROR: syntax error, unexpected INTVAL	working as expected
SIN	SELECT sin(pi()/2);	unknown function pi	working as expected
/	1/0	error division(s) by zero	error division(s) by zero
	1/0.0	Infinity	error division(s) by zero
	0/0.0	NaN	error division(s) by zero

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

Operators	Description	Example	Result	Available in Oxla	Note
+	Addition	SELECT 5+8; SELECT 5 + 8; SELECT 5+ 8; SELECT 5 +8;	f ---- 13	Available
-	Subtraction	SELECT 2 - 3; SELECT 2+-3;	f ---- -1	Available
-	Negation	SELECT -4;	f ---- -4	Available
		SELECT -(-4);	f ---- 4	Available
		SELECT 5+(-2);	f ---- 3	Available
		SELECT 5-(-2);	f ---- 7	Available
*	Multiplication	SELECT 3*3; SELECT 3 + 3; SELECT 3+ 3; SELECT 3 +3;	f ---- 9	Available
/	Division	SELECT 10/2; SELECT 10 / 2; SELECT 10/ 2; SELECT 10 /2;	f ---- 5	Available
%	Modulo	SELECT 20%3; SELECT 20 % 3; SELECT 20% 3; SELECT 20 %3;	f ---- 2	Available
&	Bitwise AND	91 & 15	f ---- 91	Available	the result is different from PostgreSQL
#	Bitwise XOR	17 # 5	f ---- 17	Available	the result is different from PostgreSQL