| String Functions |
Functions for manipulating and processing text |
length, concat, replace |
| Numeric Functions |
Functions for performing calculations on numbers |
abs, ceil, floor, round |
| Date and Time Functions |
Functions for manipulating and processing dates and times |
date_trunc, to_timestamp, now |
| Aggregate Functions |
Functions for aggregating and summarizing data |
count, sum, avg, min, max, json_agg, string_agg, array_agg |
| JSON Functions |
Functions for manipulating JSON data |
->, ->>, json_build_object |
| Conditional Functions |
Functions for controlling the flow of execution based on conditions |
coalesce, greatest, least, nullif |