pgsql: Doc: clarify description of degenerate NATURAL joins.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Doc: clarify description of degenerate NATURAL joins.
Date: 2017-07-20 16:42:07
Message-ID: E1dYEWd-0001k8-VB@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Doc: clarify description of degenerate NATURAL joins.

Claiming that NATURAL JOIN is equivalent to CROSS JOIN when there are
no common column names is only strictly correct if it's an inner join;
you can't say e.g. CROSS LEFT JOIN. Better to explain it as meaning
JOIN ON TRUE, instead. Per a suggestion from David Johnston.

Discussion: https://postgr.es/m/CAKFQuwb+mYszQhDS9f_dqRrk1=Pe-S6D=XMkAXcDf4ykKPmgKQ@mail.gmail.com

Branch
------
REL9_2_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/80af818dd618b18d8e4b3f629844190473f2bae2

Modified Files
--------------
doc/src/sgml/queries.sgml | 4 ++--
doc/src/sgml/ref/select.sgml | 7 +++++--
2 files changed, 7 insertions(+), 4 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2017-07-20 19:28:48 pgsql: In v10 release notes, call out sequence changes as a compatibili
Previous Message Tom Lane 2017-07-20 15:29:53 pgsql: Fix dumping of outer joins with empty qual lists.