• Tom Lane's avatar
    Support hashing for duplicate-elimination in INTERSECT and EXCEPT queries. · 368df304
    Tom Lane authored
    This completes my project of improving usage of hashing for duplicate
    elimination (aggregate functions with DISTINCT remain undone, but that's
    for some other day).
    
    As with the previous patches, this means we can INTERSECT/EXCEPT on datatypes
    that can hash but not sort, and it means that INTERSECT/EXCEPT without ORDER
    BY are no longer certain to produce sorted output.
    368df304
union.out 7.77 KB