8.2.13. LOG()
Available in
DSQL, PSQL
Possible name conflict
YES → Read details
Syntax
LOG (x, y)
Parameter | Description |
---|---|
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.