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

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

exp

exp() returns e^n, where e is the base of the natural logarithm, and n is the value of the argument expression.

Syntax: e(expression)

Returns:

An agtype Float.

Arguments:

Considerations:

• exp(null) returns null.

Query:

SELECT *
FROM cypher('graph_name', $$
    RETURN e(2)
$$) as (e agtype);

e to the power of 2 is returned.

Result:

log

log() returns the natural logarithm of a number.

Syntax:log(expression)

Returns:

An agtype Float.

Arguments:

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:

log10

log10() returns the common logarithm (base 10) of a number.

Syntax:log10(expression)

Returns:

An agtype Float.

Arguments:

Considerations:

• log10(null) returns null.
• log10(0) returns null.

Query:

SELECT *
FROM cypher('graph_name', $$
    RETURN log(27)
$$) as (natural_logarithm agtype);

The common logarithm of 27 is returned.

Result: