LOG()

Available in: DSQL, PSQL

Added in: 2.1

Description

Returns the x-based logarithm of y.

Result type: DOUBLE PRECISION

Syntax

LOG (x, y)

• If x is negative or y is negative, the result is always NaN.
• If x is positive and y is 0, +/-INF is returned, depending on x.
• Bug: If x = 1 and y >= 0 (but not 1), +/-INF is returned.
• Bug: If x = 0 and y > 0, the result is 0.

Important: If the external function LOG is declared in your database, it will override the internal function. To make the internal function available, DROP or ALTER the external function (UDF).