array_contains

Description

Tests if an array contains a value.

Returns true if array arr contains a value equal to val, where val is of variant type.

Returns false if the value is not contained. null is returned if either input parameter is null.

Note that this function considers null equal to null, and can therefore be used to check if an array contains null values.

Return type

bool

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

array_contains(arr, val)

Argument

Type

Optional

Repeatable

Restrictions

arr

array

no

no

none

val

storable

no

no

none

Examples

filter array_contains(names, "Bob")

Filter to include all rows whose names column (an array) contains the value Bob.

filter array_contains(phone_numbers, variant_null())

Filter to include rows where the phone_numbers column (an array) contains a null value.