A function is an operation that is denoted by a function name followed by a pair of parentheses that enclose arguments (there might be no 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 functionsare registered to the database by using the CREATE FUNCTION statement. There are two types of user-defined functions:
▪ Stored functions can be written in the solidDB proprietary SQL procedure language.
▪ External stored functions 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. External stored functions enable you to expand the server functionality by writing a C program.