• Tom Lane's avatar
    Teach planner and executor to handle ScalarArrayOpExpr as an indexable · 290166f9
    Tom Lane authored
    qualification when the underlying operator is indexable and useOr is true.
    That is, indexkey op ANY (ARRAY[...]) is effectively translated into an
    OR combination of one indexscan for each array element.  This only works
    for bitmap index scans, of course, since regular indexscans no longer
    support OR'ing of scans.  There are still some loose ends to clean up
    before changing 'x IN (list)' to translate as a ScalarArrayOpExpr;
    for instance predtest.c ought to be taught about it.  But this gets the
    basic functionality in place.
    290166f9
nodeIndexscan.c 23.9 KB