Re: pgsql/src/test/regress/expected (union.out)

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."

In response to

Responses

Browse pgsql-committers by date

  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)