A function is an operation that is denoted by a function name that is followed by a pair of parentheses that enclose the specification of zero, one, or more arguments. In addition to built-in functions, solidDB supports both internal and external user-defined stored functions.
Built-in functions are provided within the database engine.
User-defined functions are registered to the database by using the CREATE FUNCTION statement. There are two types of user-defined functions:
▪ User-defined stored functions that can be written in the solidDB proprietary SQL procedure language.
▪ User-defined external stored functions that can be written in the C programming language. External stored functions are loaded at runtime by using standard dynamic library interfaces that are provided by the operating system.
Note Some built-in functions listed below are derived from ODBC standards instead of SQL standards and follow ODBC syntax instead of SQL syntax. Please be aware that there may be some incompatibilities with certain built-in functions.