]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 41ada83) | 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:33 +0000 (12:41 -0400)
commit5512427b19e79ac95535e7c942bd479db807f7be
treea7bc823d5ae582f4cd8b05f4521621fc476f5e7dtree | snapshot
parent41ada83774929c3bbb069a90f2aa3a8ac508e876commit | 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 | history
doc/src/sgml/ref/select.sgml diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.