risingwave_expr_impl::scalar::array_contain

Function array_contains

Source 
fn array_contains(left: ListRef<'_>, right: ListRef<'_>) -> bool
Expand description

Returns whether left range contains right range.

Examples:

query I
select array[1,2,3] @> array[2,3];
----
t

query I
select array[1,2,3] @> array[3,4];
----
f

query I
select array[[[1,2],[3,4]],[[5,6],[7,8]]] @> array[2,3];
----
t

query I
select array[1,2,3] @> null;
----
NULL

query I
select null @> array[3,4];
----
NULL