EXP

7min

Overview
The EXP() function returns the exponential value of a number specified in the argument.
Syntax
The syntax for the EXP() is:
Pgsql
EXP(number);
EXP(number);
﻿
Where:
number: The number for which you want to calculate the exponential value. Equivalent to the formula e^number.
Examples
Let's explore examples to see how the EXP() function works.
Case #1: Basic Usage
In this case, we use the EXP() function with positive and negative values.
Pgsql
SELECT EXP(0) AS "EXP of 0", 
      EXP(1) AS "EXP of 1",
      EXP(2) AS "EXP of 2",
      EXP(-1) AS "EXP of -1",
      EXP(-2) AS "EXP of -2";
SELECT EXP(0) AS "EXP of 0", 
      EXP(1) AS "EXP of 1",
      EXP(2) AS "EXP of 2",
      EXP(-1) AS "EXP of -1",
      EXP(-2) AS "EXP of -2";
﻿
You will get the following result:
Pgsql
EXP of 0  |     EXP of 1      |     EXP of 2     |      EXP of -1      |     EXP of -2      
----------+-------------------+------------------+---------------------+--------------------
        1 | 2.718281828459045 | 7.38905609893065 | 0.36787944117144233 | 0.1353352832366127
EXP of 0  |     EXP of 1      |     EXP of 2     |      EXP of -1      |     EXP of -2      
----------+-------------------+------------------+---------------------+--------------------
        1 | 2.718281828459045 | 7.38905609893065 | 0.36787944117144233 | 0.1353352832366127
﻿
Case #2: Using EXP() with Fractions
This case uses the EXP() function with a fractional argument.
Pgsql
SELECT EXP(3.2);
SELECT EXP(3.2);
﻿
Here is the result:
Pgsql
        exp         
--------------------
 24.532531366911574
        exp         
--------------------
 24.532531366911574
﻿
Case #3: Using EXP() with Expressions
Here, we use the EXP() function with expressions.
Pgsql
SELECT EXP(5 * 5);
SELECT EXP(5 * 5);
﻿
See the result below:
Pgsql
        exp        
-------------------
 72004899337.38588
        exp        
-------------------
 72004899337.38588
﻿
﻿

Updated 23 Oct 2023

Did this page help you?

ROUND

LOG

Docs powered by Archbee

TABLE OF CONTENTS

Case #2: Using EXP() with Fractions

Case #3: Using EXP() with Expressions