]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: eb145fd) | 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:26 +0000 (12:41 -0400)
commited3dc224e5aabd3cb0a5c348107f973fe5b10b0d
treeece8d0c328fc8523a6ea95810a015e623f524175tree | snapshot
parenteb145fdfea91ee5dc6d7aad0309527f810f7c90acommit | 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.