Logarithmic Functions

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) returns null.

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) returns null.
log(0) returns null.

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) returns null.
log10(0) returns null.

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