Arithmetic operators
Arithmetic operators usually operate on numeric values.
The following table lists the operator functions for the arithmetic
operators that the database server provides.
| Arithmetic operator | Operator function |
|---|---|
| + (binary) | plus() |
| - (binary) | minus() |
| * | times() |
| + (unary) | positive() |
| - (unary) | negate() |
| / | divide() |
You can overload these operators so that you can use them with user-defined types. For an example of overloading the plus() and divide() functions, refer to Example of a user-defined aggregate.