LOG()

Tip

Find a more recent version at Firebird 5.0 Language Reference: 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.

Much of this behaviour is going to change in Firebird 2.5.

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