Functions
Functions
The NYXDB function reference: 23 families, each function with its signatures, behaviour and an example.
This reference lists 991 functions in 23 families. Every function runs in one-shot queries, transformations and streaming queries alike, with the streaming behaviour stated on its entry.
A function name resolves case-insensitively. Comparison and logical operators (=, <, AND, IS NULL, IN) are part of the SQL grammar, not entries here.
Families
| Family | Functions |
|---|---|
| Aggregate | 45 |
| Array | 95 |
| Bit | 13 |
| Conditional | 3 |
| Date and time | 145 |
| Encoding | 12 |
| Financial | 2 |
| Geospatial | 60 |
| Hash | 28 |
| IP address | 12 |
| JSON | 80 |
| Map | 20 |
| Math | 57 |
| NULL handling | 7 |
| Statistical | 106 |
| String | 81 |
| Table | 4 |
| Time series | 29 |
| Tuple | 14 |
| Type conversion | 131 |
| URL | 26 |
| UUID | 8 |
| Window | 13 |