Operator functions
An operator function is an SQL-invoked function that has a corresponding operator symbol (such as '=' or '+'). These operator symbols are used within expressions in an SQL statement.
Operator binding is the implicit invocation of an operator
function when an operator symbol is used in an
SQL statement. The database server implicitly maps a built-in operator
function name to a built-in operator. For example, you can compare
two values for equality in either of the following ways.
- Operator function
- equal(value1, value2)
- Operator symbol
- value1 = value2
The following topics summarize how you can extend an operator on built-in and UDTs. For more information about how to extend operators, refer to Extend operators and built-in functions.