EXP

Returns the natural exponent value of a numeric expression (ex)

See also LOG.

Syntax

EXP( expr )

Arguments

Parameter

Description

expr

Positive numeric expression

Returns

Always returns a floating point result.

Notes

  • If the input value is NULL, the result is NULL.

Examples

Natural exponent values

numbers=> SELECT EXP(x) FROM (VALUES (1.0), (2.0), (4.0)) as t(x);
   exp
-------
 2.7183
 7.3891
54.5982