ARRAY_LENGTH
Returns the length of the given array, i.e., how many elements it contains. Produces NULL for NULL arrays.
Synonym: LENGTH (when used with an array argument)
Syntax
ARRAY_LENGTH(<array>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<array> | The array whose length should be calculated | ARRAY |
Return Type
INTEGER
Example
SELECT
ARRAY_LENGTH([ 1, 2, 3, 4 ]) AS levels;
Returns: 4
SELECT
ARRAY_LENGTH([ [ 1, 2, 3 ], [ 4, 5, 6, 7 ]) AS levels;
Returns: 2