8.2.13. LOG()

Available in

DSQL, PSQL

Possible name conflict

YES → Read details

Syntax

  1. LOG (x, y)
Table 111. LOG Function Parameters
ParameterDescription

x

Base. An expression of a numeric type

y

An expression of a numeric type

Result type

DOUBLE PRECISION

Description

Returns the x-based logarithm of 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.