↑↓ select↵ open⌫ change scopeOpen full search

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

Unsupported versions: 6.5
Historical version. PostgreSQL 6.5 has reached end of support. See the current manual.

Mathematical Functions

Table 5-2. Mathematical Functions

FunctionReturnsDescriptionExample
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.