LOG()

<< LN() | FB 2.1 Language Reference | LOG10() >>

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

back to top of page
<< LN() | FB 2.1 Language Reference | LOG10() >>