Function ArrayContains

pkg/sql/sem/tree/eval.go:358–383

ArrayContains return true if the haystack contains all needles.

(
	ctx context.Context, cmpCtx CompareContext, haystack *DArray, needles *DArray,
)

// ArrayContains return true if the haystack contains all needles.
func ArrayContains(
	ctx context.Context, cmpCtx CompareContext, haystack *DArray, needles *DArray,
) (*DBool, error) {
	if !haystack.ParamTyp.Equivalent(needles.ParamTyp) {
		return DBoolFalse, pgerror.New(pgcode.DatatypeMismatch, "cannot compare arrays with different element types")
	}
	for _, needle := range needles.Array {
		// Nulls don't compare to each other in @> syntax.
		if needle == DNull {
			return DBoolFalse, nil
		}
		var found bool
		for _, hay := range haystack.Array {
			if cmp, err := needle.Compare(ctx, cmpCtx, hay); err != nil {
				return DBoolFalse, err
			} else if cmp == 0 {
				found = true
				break
			}
		}
		if !found {
			return DBoolFalse, nil
		}
	}
	return DBoolTrue, nil
}

// ArrayOverlaps return true if there is even one element
// common between the left and right arrays.