15.00 - Chapter 4 ARRAY/VARRAY Functions and Operators - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)
Last Update
2018-09-24

This chapter describes functions, operators, expressions and methods that operate on either one-dimensional (1-D), multidimensional (n-D), or both ARRAY data types. These functions allow you to perform arithmetic, relational, and aggregate operations on an array in its entirety or on a subset of the elements composing an array.

For information on the ARRAY data type, see "ARRAY/VARRAY Data Type" in SQL Data Types and Literals. For information on creating one-dimensional and multi-dimensional arrays, see "CREATE TYPE (ARRAY/VARRAY Form)" in SQL Data Definition Language Syntax and Examples.

Note: The functions in this chapter are embedded services system functions. For information on activating and invoking embedded services functions, see “Embedded Services System Functions” on page 24.