17.10 - ARRAY_COMPARISON_FUNCTION Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

System Function

{ ARRAY_GT |
  ARRAY_GE |
  ARRAY_LT |
  ARRAY_LE |
  ARRAY_EQ |
  ARRAY_NE
} ( expr1, expr2 [, scope_reference ] )

Method-Style

expr1.{ ARRAY_GT |
       ARRAY_GE |
       ARRAY_LT |
       ARRAY_LE |
       ARRAY_EQ |
       ARRAY_NE
     } ( expr2 [, scope_reference ] )

Syntax Elements

expr1
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
scope_reference
An ARRAY scope reference.