Scalar FunctionsDynamic / JSON Functions
array_shift_left
Shift the elements of a dynamic array by `count` positions to the left.
Positive counts drop elements from the front and right-pad with
fill (default null); negative counts shift right instead. Shifts
at least as large as the array fill the entire output with fill.
Syntax
array_shift_left(array, count, fill)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1
print array_shift_left(dynamic([1, 2, 3, 4, 5]), 2, -1)| print_0 (dynamic) |
|---|
| [3,4,5,-1,-1] |