EXP

Reference material for EXP function

Returns the value of the constant e raised to the power of the specified number.

Syntax

EXP(<value>)

Parameters

Parameter	Description	Supported input types
<value>	The exponent to raise e to.	DOUBLE PRECISION (implicit cast from INTEGER, BIGINT, REAL)

Return Type

DOUBLE PRECISION

Remarks

• EXP(NULL) returns NULL.
• EXP('NaN') returns NaN.
• EXP('Infinity') returns Infinity.
• EXP('-Infinity') returns 0.
• If the result would overflow or underflow the DOUBLE PRECISION range, an error is raised. To check whether a value is finite before calling EXP, use IS_FINITE.
• NUMERIC arguments are not accepted; cast them explicitly to DOUBLE PRECISION first.

Example

The following example raises e to the power of 2:

SELECT EXP(2);

exp double
7.38905609893065

Rows: 1Execution time: 2.19ms

The following example shows special value handling:

SELECT EXP('infinity'::DOUBLE PRECISION) AS pos_inf, EXP('-infinity'::DOUBLE PRECISION) AS neg_inf;

pos_inf double	neg_inf double
inf	0

Rows: 1Execution time: 4ms