September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 6.5
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

Mathematical Functions

Table 5-2. Mathematical Functions

Function Returns Description Example
dexp(float8) float8 raise e to the specified exponent dexp(2.0)
dpow(float8,float8) float8 raise a number to the specified exponent dpow(2.0, 16.0)
float(int) float8 convert integer to floating point float(2)
float4(int) float4 convert integer to floating point float4(2)
integer(float) int convert floating point to integer integer(2.0)