Re: pgsql/src/test/regress/expected (union.out)
От | Alfred Perlstein |
---|---|
Тема | Re: pgsql/src/test/regress/expected (union.out) |
Дата | |
Msg-id | 20001005140938.F27736@fw.wintelcom.net обсуждение исходный текст |
Ответ на | pgsql/src/test/regress/expected (union.out) (Tom Lane <tgl>) |
Ответы |
Re: pgsql/src/test/regress/expected (union.out)
|
Список | pgsql-committers |
* 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."
В списке pgsql-committers по дате отправления: