The functions and operators the VAST Query Engine evaluates, by group. Read Overview first to see why a function on a column runs after the scan, then Operators and predicates; the other pages list each group's functions and what isn't available.
- Overview: How the VAST Query Engine evaluates functions and operators, and why only column-to-constant comparisons are evaluated in VAST DataBase.
- All functions A-Z: Every SQL function name the VAST Query Engine knows, with a link to its page, and the names it doesn't have, with what to use instead.
- String: Text functions on VARCHAR values, in four pages. Start with Text basics for length, case, substrings and replacing; Search and split covers finding text and splitting it, Trimming and padding the fixed-width forms, and Regular expressions the regexp functions.
- Aggregate and analytic functions: Every aggregate the VAST Query Engine runs, with types, NULL handling and an example each, how they run and how to make them faster.
- JSON functions: Every JSON function the VAST Query Engine runs on JSON text in VARCHAR columns, with paths, types, NULL handling and how to speed them up.
- Date and time functions: Every date, time and interval function the VAST Query Engine runs, what fails without time zones, and how to keep date filters fast.
- Numeric and math functions: Every rounding, arithmetic, math, bit and number-formatting function the VAST Query Engine runs, with types, NULLs, errors and an example each.
- Conditional and conversion functions: CAST, TRY_CAST, CASE, coalesce, nullif, greatest and least in the VAST Query Engine, with types, NULL handling and pushdown.
- List functions: Every list, lambda, struct and map function the VAST Query Engine runs, with types, NULL handling, how they run and how to speed them up.
- Map functions: map_concat, map_from_entries, map, map_entries and 9 more.
- Struct functions: struct_extract_at, struct_extract, struct_pack, row and 2 more.
- Utility functions: Settings, variables and the search path, logging, PostgreSQL-compatible helpers, sort keys and type names.
- Table functions: Table functions such as range, generate_series and unnest that the VAST Query Engine runs in FROM, and what replaces file readers.
- Enum functions: enum_code, enum_first, enum_last, enum_range_boundary and 1 more.
- Binary, hash and UUID functions: Bit strings, BLOB data and encodings, hashes, UUIDs and enums in the VAST Query Engine, with types, NULL handling and examples.
- Operators: Comparison, logical, pattern-matching, arithmetic, bitwise and list operators in the VAST Query Engine, and which predicates VAST DataBase evaluates itself.
- Vector distance functions: array_cosine_distance, array_distance, array_negative_inner_product.