• Tom Lane's avatar
    Implement SQL-compliant treatment of row comparisons for < <= > >= cases · 6e077097
    Tom Lane authored
    (previously we only did = and <> correctly).  Also, allow row comparisons
    with any operators that are in btree opclasses, not only those with these
    specific names.  This gets rid of a whole lot of indefensible assumptions
    about the behavior of particular operators based on their names ... though
    it's still true that IN and NOT IN expand to "= ANY".  The patch adds a
    RowCompareExpr expression node type, and makes some changes in the
    representation of ANY/ALL/ROWCOMPARE SubLinks so that they can share code
    with RowCompareExpr.
    
    I have not yet done anything about making RowCompareExpr an indexable
    operator, but will look at that soon.
    
    initdb forced due to changes in stored rules.
    6e077097
lsyscache.c 47.2 KB