ARRAY_ARITHMETIC_FUNCTION

Teradata Vantageā„¢ Data Types and Literals

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Purpose

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

Method-Style

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.