Performs arithmetic operations (add, subtract, multiply, divide, and mod) on an ARRAY value, whether referred to in its entirety or over a scope reference.
Syntax
System Function
{ ARRAY_ADD |
ARRAY_SUB |
ARRAY_MUL |
ARRAY_DIV |
ARRAY_MOD
} ( expr1, expr2 [, scope_reference ] )
Method-Style
expr1.{ ARRAY_ADD | ARRAY_SUB | ARRAY_MUL | ARRAY_DIV | ARRAY_MOD } ( expr2 [, scope_reference ] )
- expr1/expr2
-
An ARRAY expression, which is one of the following:
- A reference to an ARRAY column
- An ARRAY constructor expression
- A UDF expression
- A UDM expression
The element type of the array must be a numeric data type.
- scope_reference
- An ARRAY scope reference.