| From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)hub(dot)org> |
| Cc: | pgsql-committers(at)postgresql(dot)org |
| Subject: | Re: pgsql/src/test/regress/expected (union.out) |
| Date: | 2000-10-05 21:09:38 |
| Message-ID: | 20001005140938.F27736@fw.wintelcom.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
* Tom Lane <tgl(at)hub(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-05 21:32:22 | Re: pgsql/src/test/regress/expected (union.out) |
| Previous Message | Tom Lane | 2000-10-05 20:18:34 | pgsql/src/backend/libpq (pqcomm.c) |