ELEMENT_AT_POS
All functions > ARRAY > ELEMENT_AT_POS
Returns the element at the specified position in an array.
Signatures
Returns: The element at the specified position
ELEMENT_AT_POS(array: ARRAY<T>, position: BIGINT) → Tsql
| Parameter | Type | Required | Description |
|---|---|---|---|
array | ARRAY<T> | Yes | The array to access |
position | BIGINT | Yes | 1-based position (negative values count from end) |
Notes
- Uses 1-based indexing (first element is at position 1)
- Negative positions count from the end (-1 is last element)
- Returns NULL if position is out of bounds
- Returns NULL if array is NULL
On this page