]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 6ab4a11) | patch
Doc: clarify description of degenerate NATURAL joins.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 20 Jul 2017 16:41:26 +0000 (12:41 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 20 Jul 2017 16:41:41 +0000 (12:41 -0400)
commit769eaef7600b0cc63bdc488428c4e01902261a73
treeb717a6cd542cd7eeda42f317e9fe001d8635165atree
parent6ab4a1136ed949fa77e74d97dd4fecdb8bc8c380commit | diff
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
doc/src/sgml/queries.sgml diff | blob | blame | history
doc/src/sgml/ref/select.sgml diff | blob | blame | history
Mirror of https://git.postgresql.org/git/postgresql.git