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

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

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.