• T
    Reimplementation of UNION/INTERSECT/EXCEPT. INTERSECT/EXCEPT now meet the · 05e3d0ee
    Tom Lane 提交于
    SQL92 semantics, including support for ALL option.  All three can be used
    in subqueries and views.  DISTINCT and ORDER BY work now in views, too.
    This rewrite fixes many problems with cross-datatype UNIONs and INSERT/SELECT
    where the SELECT yields different datatypes than the INSERT needs.  I did
    that by making UNION subqueries and SELECT in INSERT be treated like
    subselects-in-FROM, thereby allowing an extra level of targetlist where the
    datatype conversions can be inserted safely.
    INITDB NEEDED!
    05e3d0ee
nodeAppend.c 14.6 KB