ARRAY_CONTAINS

ARRAY_CONTAINS(elem, arr)

Returns true if elem is an element of arr, or NULL if arr is NULL. The input elem can be NULL, in which case the funciton will check if arr contains NULL.