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

ParameterDescriptionSupported 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

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

ParameterDescriptionSupported 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