LOG()

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

LOG()

Available in: DSQL, PSQL

Added in: 2.1

Changed in: 2.5

Description

Returns the x-based logarithm of y.

Result type: DOUBLE PRECISION

Syntax

 LOG (x, y)


  • If either argument is 0 or below, an error is raised. (Before 2.5, this would result in NaN, ±INF or 0, depending on the exact values of the arguments.)
  • If both arguments are 1, NaN is returned.
  • If x = 1 and y < 1, -INF is returned.
  • If x = 1 and y > 1, INF is returned.

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.5 Language Reference | LOG10() >>