ARRAY_UPPER

Returns the maximum index that can be used for an array. Produces NULL for NULL arrays. Because Firebolt currently does not support array slices, the maximum index is always the length of the array. This function is currently only implemented for the second parameter being 1.

Syntax

ARRAY_UPPER(<array>, <int>)

Parameters

Parameter	Description	Supported input types
`<array>`	The array whose upper bound should be calculated	`ARRAY`
`<int>`	The dimension to look at, for multi-dimensional arrays	`INTEGER`

Return Type

INTEGER

Examples

SELECT ARRAY_UPPER([1, 2, 3], 1);

array_upper int
3

Rows: 1Execution time: 5.12ms

SELECT ARRAY_UPPER([[1, 2], [3, 4], [5, 6]], 1);

array_upper int
3

Rows: 1Execution time: 4.58ms

ARRAY_TO_STRING

ARRAYS_OVERLAP

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Return Type

Examples

​Syntax

​Parameters

​Return Type

​Examples

Syntax

Parameters

Return Type

Examples