ELEMENTS_AT_POS
All functions > ARRAY > ELEMENTS_AT_POS
Returns the elements at multiple specified positions in an array.
Syntax
ELEMENTS_AT_POS(array: ARRAY<T>, positions: ARRAY<BIGINT>) → ARRAY<T>sql
Type Parameters:
T: Any type
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
array | ARRAY<T> | Yes | The array to access |
positions | ARRAY<BIGINT> | Yes | Array of 1-based positions to extract |
Returns
ARRAY - Array containing elements at the specified positions
Notes
- Uses 1-based indexing for positions
- Negative positions count from the end
- Out of bounds positions return NULL for that element
- Preserves the order of positions array