Reference material for ARRAYS_OVERLAP function
NULL
element.
Note that if the input arrays have only a NULL
element in common, ARRAYS_OVERLAP
returns FALSE
.
Returns NULL
if any of the inputs is NULL
.
Parameter | Description | Supported input types |
---|---|---|
<array_1>, <array_2> [, ...n] | Two or more arrays to be tested for common elements. | ARRAY |
BOOLEAN
TRUE
because all input arrays contain the element 2
.
have_overlap (BOOLEAN) |
---|
t |
FALSE
because no element appears in all input arrays.
have_overlap (BOOLEAN) |
---|
f |
FALSE
because no non-NULL
element appears in all input arrays.
have_overlap (BOOLEAN) |
---|
f |
NULL
because one of the inputs is NULL
.
have_overlap (BOOLEAN) |
---|
NULL |