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