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: | Raw Message | Whole Thread | 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 |