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
    f1 := ELEMENTS_AT_POS(ARRAY[10, 20, 30, 40], ARRAY[4, 1]), -- Order follows positions array
    f2 := ELEMENTS_AT_POS(ARRAY[10, 20, 30], ARRAY[3, 1]) -- Multiple positions
;