ARRAY_REPLACE_BACKWARDS
Scans an array <array> from the last to the first element and replaces each of the elements in that array with array[i + 1] if the <function> returns 0. The last element of <array> is not replaced.
The <function> parameter must be included.
Syntax
ARRAY_REPLACE_BACKWARDS(<function>, <array>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<function> | A Lambda function used to check elements in the array. | Any Lambda function |
<array> | The array to be evaluated by the function. | Any array |
Return Type
ARRAY of the same type as the input array
Example
The following example replaces elements of the array that meet the condition x > 2:
SELECT
ARRAY_REPLACE_BACKWARDS(x -> x > 2, [ 1, 2, 3, 9 ]) AS levels;
Returns: 3,3,3,9