18th October 2018: PostgreSQL 11 Released!
Unsupported versions: 6.5

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)