Array contains all

Array contains-all operator.

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

Category: comparison

SQL symbol: @>>

Example

SELECT ARRAY[1,2] @>> ARRAY[1,2];

Signatures

  • array @>> array → boolean

Types

  • Left: array
  • Right: array
  • Result: boolean