Function array_remove

fn array_remove(
    array: ListRef<'_>,
    elem: Option<ScalarRefImpl<'_>>,
) -> ListValue

Removes all elements equal to the given value from the array. Note the behavior is slightly different from PG.

Examples:

query T
select array_remove(array[array[1],array[2],array[3],array[2],null], array[1]);
----
{{2},{3},{2},NULL}

query T
select array_remove(array[array[1],array[2],array[3],array[2],null], array[2]);
----
{{1},{3},NULL}

query T
select array_remove(array[array[1],array[2],array[3],array[2],null], null);
----
{{1},{2},{3},{2}}

query T
select array_remove(array[array[1],array[2],array[3],array[2],null], array[4]);
----
{{1},{2},{3},{2},NULL}

query T
select array_remove(null, 1);
----
NULL

query T
select array_remove(ARRAY[array[1],array[2],array[3],array[2],null], array[3.14]);
----
{{1},{2},{3},{2},NULL}

query T
select array_remove(array[1,NULL,NULL,3], NULL);
----
{1,3}

statement error
select array_remove(array[array[1],array[2],array[3],array[2],null], 1);

statement error
select array_remove(array[array[1],array[2],array[3],array[2],null], array[array[3]]);

statement error
select array_remove(ARRAY[array[1],array[2],array[3],array[2],null], array[true]);