fn array_contains(left: ListRef<'_>, right: ListRef<'_>) -> boolExpand 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