Differences Between Oxla vs. PostgreSQL

​

1. Functions

​

a) Mathematical

A mathematical function operates on input values provided as arguments and returns a numeric value as the operation’s output.

​

b) Trigonometric

​

2. Operators

​

a) Mathematical Operators

Below is a list of mathematical operators available in PostgreSQL:

​

b) JSON Operators

Oxla supports operators for handling JSON data. One such operator is:

​

Equal Operator (=)

This operator checks if two JSON values are identical. In Oxla, this operator is order-sensitive which means that for two JSON objects to be considered equal, their key-value pairs must appear in the exact same order.

SELECT '{"a":1, "b":"c"}'::json = '{"b":"c", "a":1}'::json;

Result:

 ?column? 
----------
 f
(1 row)

​

3. Behaviors Difference

​

a) Output Header

Missing function name in output header, PostgreSQL shows the function name, like in this example:

SELECT COS(0),LN(1);

cos  | ln 
-----+-----
 1   | 0

Oxla does not show the function name, like in this example:

SELECT COS(0),LN(1);

 f | f_1 
---+-----
 1 | 0

​

b) ABS Output

Differences 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

SELECT ABS(-1.0);

It returns 1 in Oxla, while in PostgreSQL, it produces 1.0

​

4. Errors Difference