ARRAY_ROTATE()

All functions > ARRAY > ARRAY_ROTATE()

Returns a new array whose elements are rotated circularly; positive amounts shift left, negative amounts shift right.

Signatures

Returns: Rotated array with the same element type

ARRAY_ROTATE(array: ARRAY<T>, amount: BIGINT) → ARRAY<T>

Notes

• Amount is applied modulo the array length (zero-length arrays are unchanged)
• Uses integer rotation counts only

See also

• Array functions

Examples

SELECT
    f1 := ARRAY_ROTATE(ARRAY[1, 2, 3, 4], 1) -- Rotate left by one
;