select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 6.5
Historical version. PostgreSQL 6.5 reached end of support in June 2004. See the current manual for supported releases.

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)

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.