* Tom Lane <tgl@hub.org> [001005 12:12] wrote:
> Date: Thursday, October 5, 2000 @ 15:11:39
> Author: tgl
>
> Update of /home/projects/pgsql/cvsroot/pgsql/src/test/regress/expected
> from hub.org:/home/projects/pgsql/tmp/cvs-serv22406/src/test/regress/expected
>
> Modified Files:
> union.out
>
> ----------------------------- Log Message -----------------------------
>
> Reimplementation of UNION/INTERSECT/EXCEPT. INTERSECT/EXCEPT now meet the
> 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!
Does this mean that in the next release EXCEPT will be a lot faster?
Will I probably be able to drop my "NOT EXISTS" hacks that I've
been using?
thanks,
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."