| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: 8.4 release notes proof reading 1/2 |
| Date: | 2009-03-27 22:40:00 |
| Message-ID: | 200903272240.n2RMe0v09811@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Andrew Gierth wrote:
> >>>>> "Guillaume" == Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com> writes:
>
> Guillaume> - "While semi-joins merely replace existing IN joins,
> Guillaume> anti-joins are a new capability for NOT IN and NOT EXIST
> Guillaume> clauses (Tom) This improves optimization possibilities."
> Guillaume> -> remove the "(Tom)", s/EXIST/EXISTS/
>
> Also s/NOT IN and // (anti-joins are not used for NOT IN due to the
> awkward semantics of nulls). Should possibly also mention the fact that
> some outer joins can be planned as anti-joins too.
Thanks, text updated:
While semi-joins merely replace existing IN joins, anti-joins
are a new capability for NOT EXISTS clauses (Tom) This improves
optimization possibilities.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2009-03-27 22:42:28 | Re: SSL over Unix-domain sockets |
| Previous Message | Alvaro Herrera | 2009-03-27 22:27:44 | Re: typedefs for indent |