Try Opteryx

Array contains all

Returns true when the left array contains all values from the right array.

Category: comparison

SQL symbol: @>>

Syntax

sql
<array> @>> <values>

Parameters

  • <array> — The array to search. Accepts array.
  • <values> — The array of values that must ALL be present for the result to be true. Accepts array.

Returns

boolean

Examples

sql
SELECT ['a','b'] @>> ['a','b'];
true
sql
SELECT ['a','b'] @>> ['a','z'];
false

Signatures

  • array @>> array → boolean

Notes

@>> is ALL, @> is ANY.

See Also