array_contains

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] @> array[3,1];
----
t

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

query I
SELECT array[1,2,3] @> array[]::int[];
----
t

query I
SELECT ARRAY[]::int[] @> ARRAY[]::int[];
----
t

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

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

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

query I
SELECT array[1,NULL,2] @> array[NULL]::int[];
----
f

query I
SELECT NULL::int[] @> ARRAY[1];
----
NULL