ELEMENTS_AT_POS()

All functions > ARRAY > ELEMENTS_AT_POS()

Returns the elements at multiple specified positions in an array.

Signatures

Returns: Array containing elements at the specified positions

ELEMENTS_AT_POS(array: ARRAY<T>, positions: ARRAY<BIGINT>) → ARRAY<T>

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

See also

• Array functions

Examples

SELECT
    -- Order follows positions array
    f1 := ELEMENTS_AT_POS(ARRAY(10, 20, 30, 40), ARRAY(4, 1)),
    -- Multiple positions
    f2 := ELEMENTS_AT_POS(ARRAY(10, 20, 30), ARRAY(3, 1))
;