A user-defined function interface provides independent capabilities to a user purpose function.
The following features and capabilities are provided by the MySQL interface for user-defined functions:
- Functions can accept arguments of integer, string, or real values and can return values for the same types
- Simple functions can be defined to operate on a single row at a time or it can be aggregate functions to operate on groups of rows
- Functions are given information to enable them so that they can check the types, names, and numbers of arguments passed
- Before passing arguments to the given function, you can also ask MySQL to coerce arguments
- Indications can be made if the function results in any ...