SQL functions
Postgres builtin functions and operators (a sample)
Mathematics
| Function |
Description |
Example |
Result |
| abs(x) |
absolute value |
abs(-4.19) |
4.19 |
| ln(x) |
Natural log |
ln(2.0) |
0.693147180559945 |
| log(x) |
Base 10 logarithm |
log(100.0) |
2 |
| pi() |
You know, pi |
pi() |
3.14159265358979 |
| sin(x) |
sine |
sin(radians(30.0)) |
0.5 |
| radians(x) |
Convert degrees to radians |
radians(30.0) |
0.523598775598299 |
| asin(x) |
inverse sine |
asin(0.5) |
0.523598775598299 |
|