Skip to content
Machbase DBMS Manual
16. Reference
16.1 SQL Reference
16.1.3 Function Dictionary

16.1.3 Function Dictionary

Built-in functions organized by category.

CategoryDescription
Aggregate FunctionsGroup aggregates such as COUNT, SUM, AVG, MIN, MAX, STDDEV, FIRST, and LAST
Window/Series FunctionsWindow and series analysis functions such as ROWNUM and SERIESNUM
Date/Time FunctionsDate/time processing with TO_DATE, TO_CHAR, DATE_TRUNC, ADD_TIME, and others
JSON Functions and Dot NotationJSON extraction, modification, and member access
Regular Expression FunctionsRegex search and transformation with REGEXP_LIKE, REGEXP_SUBSTR, and others
NEXTVALAutomatic sequence values for Lookup table sequence columns
User Context FunctionsCURRENT_USER, SESSION_USER, and internal user IDs
Complete Function ReferenceComplete reference, including existing functions and CAST

Common Rules

  • NULL input produces NULL output unless otherwise stated.
  • Argument type mismatches produce ERR-02036 or ERR-02037.
Last updated on