e
e() returns the base of the natural logarithm, e.
Syntax: e()
Returns:
An agtype float.
Query
SELECT *FROM cypher('graph_name', $$RETURN e()$$) as (e agtype);
Results
| e |
| 2.71828182845905 |
| 1 row(s) returned |
sqrt
sqrt() returns the square root of a number.
Syntax: sqrt(expression)
Returns:
An agtype float.
Query
SELECT *FROM cypher('graph_name', $$RETURN sqrt(144)$$) as (results agtype);
Results
| results |
| 12 |
| 1 row(s) returned |
exp
exp() returns e^n, where e is the base of the natural logarithm, and n is the value of the argument expression.
Syntax: exp(expression)
Returns:
An agtype float.
Arguments:
| Name | Description |
| expression | An agtype number expression |
Considerations:
exp(null)returnsnull.
Query:
SELECT *FROM cypher('graph_name', $$RETURN exp(2)$$) as (e agtype);
e to the power of 2 is returned.
Result:
| e |
| 7.38905609893065 |
| 1 row(s) returned |
log
log() returns the natural logarithm of a number.
Syntax: log(expression)
Returns:
An agtype float.
Arguments:
| Name | Description |
| expression | An agtype number expression |
Considerations:
log(null)returnsnull.log(0)returnsnull.
Query:
SELECT *FROM cypher('graph_name', $$RETURN log(27)$$) as (natural_logarithm agtype);
The natural logarithm of 27 is returned.
Result:
| natural_logarithm |
| 3.295836866004329 |
| 1 row(s) returned |
log10
log10() returns the common logarithm (base 10) of a number.
Syntax: log10(expression)
Returns:
An agtype float.
Arguments:
| Name | Description |
| expression | An agtype number expression |
Considerations:
log10(null)returnsnull.log10(0)returnsnull.
Query:
SELECT *FROM cypher('graph_name', $$RETURN log10(27)$$) as (common_logarithm agtype);
The common logarithm of 27 is returned.
Result:
| common_logarithm |
| 1.4313637641589874 |
| 1 row(s) returned |
