meta data for this page
  •  

log

Library: ib_udf

Added in: IB

Changed in: 1.5

Better alternative: Internal function LOG()

Description

In Firebird 1.5 and up, log(x,y) returns the the base-x logarithm of y. In Firebird 1.0.x and InterBase, it erroneously returns the base-y logarithm of x.

Result type: DOUBLE PRECISION

Syntax (unchanged) 

log (x, y)

Declaration (unchanged) 

DECLARE EXTERNAL FUNCTION log
  DOUBLE PRECISION, DOUBLE PRECISION
  RETURNS DOUBLE PRECISION BY VALUE
  ENTRY_POINT 'IB_UDF_log' MODULE_NAME 'ib_udf'

Warning: If any of your pre-1.5 databases uses log, check your PSQL and application code. It may contain workarounds to return the right results. Under Firebird 1.5 and up, any such workarounds should be removed or you'll get wrong results.