isEqualSet

This section contains reference documentation for the isEqualSet function.

Compares two multi-value columns (treated as sets) and returns true if they contain the same elements, regardless of order. Returns false if either argument is null.

Signature

isEqualSet(mvCol1, mvCol2)

Argument	Type	Description
mvCol1	Multi-value	First collection
mvCol2	Multi-value	Second collection

Returns: BOOLEAN

Usage Examples

SELECT isEqualSet(tags, categories) AS sameSet
FROM myTable

Returns true when the tags and categories multi-value columns contain exactly the same set of values.

SELECT isEqualSet(
  ARRAY_SORT_INT(arrayA),
  ARRAY_SORT_INT(arrayB)
) AS sameSet
FROM myTable

Two empty collections are considered equal. If either argument is null, the function returns false.