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

Chapter 10. Functions

Describes the built-in functions available in Postgres.

Many data types have functions available for conversion to other related types. In addition, there are some type-specific functions. Some functions are also available through operators and may be documented as operators only.

Mathematical Functions

Table 10-1. 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)