ELEMENT_AT
Returns the element at a location <index> from the given array. <index> can be any integer type. Indexes in an array begin at position 1.
Syntax
ELEMENT_AT(<array>, <value>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<array> | The array that the function is applied to. | ARRAY of any type |
<value> | The index that is matched by the function. Negative indexes are supported. If used, the function selects the corresponding element numbered from the end. For example, array[-1] is the last item in the array. | INTEGER |
Return Types
Same as the element data type of the input array
Example
The following example displays the player’s current level by returning the element at the index of 2:
SELECT
ELEMENT_AT([ 1, 2, 3, 4 ], 2) AS current_level;
Returns: 2