Returns true if a specified argument is present in the array, or false otherwise. Note that ARRAY_CONTAINS employs IS NOT DISTINCT FROM semantics when comparing values, i.e. NULL is considered equal to NULL.
Alias: CONTAINS
Syntax
ARRAY_CONTAINS(<array>, <value>)
Parameters
| Parameter | Description | Supported input types |
|---|
<array> | The array to be checked for the given element. | ARRAY |
<value> | The element to be searched for within the array | Any type that can be converted to the element type of the array |
Return Type
The BOOLEAN value true if the element to be searched is present in the array, or false otherwise.
Examples
Returns true, since 'danielle53' is an element of the input array:
SELECT ARRAY_CONTAINS(['sabrina21', 'rileyjon', 'ywilson', 'danielle53', NULL], 'danielle53');
| array_contains boolean |
|---|
| True |
Rows: 1Execution time: 5.39ms
false, since 'danielle53' is not an element of the input array:
SELECT ARRAY_CONTAINS(['sabrina21', 'rileyjon', 'ywilson', NULL], 'danielle53');
| array_contains boolean |
|---|
| False |
Rows: 1Execution time: 41.26ms
true, since NULL is an element of the input array:
SELECT ARRAY_CONTAINS(['sabrina21', 'rileyjon', 'ywilson', NULL], NULL);
| array_contains boolean |
|---|
| True |
Rows: 1Execution time: 10.20ms
