ARRAY_REPLACE_BACKWARDS
Scans an array <arr>
from the last to the first element and replaces each of the elements in that array with arr[i + 1]
if the <func>
returns 0
. The last element of <arr>
is not replaced.
The <func>
argument must be included.
Syntax
ARRAY_REPLACE_BACKWARDS(<func>, <arr>)
Parameter | Description |
---|---|
<func> | A Lambda function used to check elements in the array. |
<arr> | The array to be evaluated by the function. |
Example
SELECT
ARRAY_REPLACE_BACKWARDS(x -> x > 2, [ 1, 2, 3, 9 ]) AS res;
Returns: 3,3,3,9