Below is a full list of mathematical functions available in PostgreSQL.
These are arranged into the following four categories:
- Mathematical Functions
- Random Functions
- Trigonometric Functions
- Hyperbolic Functions
Mathematical Functions
abs()cbrt()ceil()ceiling()degrees()div()exp()floor()ln()log()mod()pi()power()radians()round()scale()sign()sqrt()trunc()width_bucket()
Random Functions
Trigonometric Functions
Each trigonometric function is available in two varieties; radian-based and degree-based.
