[COMMITTERS] pgsql: Doc: clarify description of degenerate NATURAL joins.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема [COMMITTERS] pgsql: Doc: clarify description of degenerate NATURAL joins.
Дата
Msg-id E1dYEWd-0001k3-V2@gemulon.postgresql.org
обсуждение исходный текст
Список 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_4_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/769eaef7600b0cc63bdc488428c4e01902261a73

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


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: [COMMITTERS] pgsql: Fix dumping of outer joins with empty qual lists.
Следующее
От: Tom Lane
Дата:
Сообщение: [COMMITTERS] pgsql: In v10 release notes,call out sequence changes as a compatibili