ARRAY_UPDATE - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Data Types and Literals

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

Purpose

Updates all or a subset of the elements in array_expr to the specified new value.

Syntax

System Function

Method-Style

array_expr
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
new_value
An expression that evaluates to a value with the same data type as the element type of array_expr.
scope_reference
An ARRAY scope reference.
array_index
Specifies one of the following:
  • An integer value.
  • An array instance of the predefined array type ArrayVec with a comma-separated list of integer values to define the bounds.
  • The value of array_index must be within the limits of array_expr.