OFIRST Function | Data Types and Literals | VantageCloud Lake - OFIRST - Teradata Vantage

Returns the lowest subscript value in array_expr as either an unsigned INTEGER value or a new instance of the predefined ARRAY type ArrayVec.

OFIRST returns an unsigned INTEGER value or a new instance of the predefined ARRAY type ArrayVec.

• OFIRST Syntax
• OFIRST Usage Notes
• OFIRST Examples

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.