Built-in Functions - EpsioΒΆ
| Category | Description | Examples |
|---|---|---|
| String Functions | Functions for manipulating and processing text | length, concat, replace, substr, length, lower, upper, lpad, md5, repeat, split_part |
| Numeric Functions | Functions for performing calculations on numbers | abs, ceil, floor, round, log |
| Date and Time Functions | Functions for manipulating and processing dates and times | date_trunc, date_part, to_timestamp, CONVERT_TZ, now, date, current_date , |
| Aggregate Functions | Functions for aggregating and summarizing data | count, sum, avg, min, max, json_agg, jsonb_agg, string_agg, array_agg, percentile_cont |
| Array Functions | Functions for manipulating arrays | array_length, json_array_contains, array_contains, indexing, slicing |
| JSON Functions | Functions for manipulating JSON data | ->, ->>, json_build_object, jsonb_build_object |
| Conditional Functions | Functions for controlling the flow of execution based on conditions | coalesce, greatest, least, nullif |
* Only supported in filter context (IE WHERE field [>|<|=] NOW())