]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 861f4fb) | 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:50 +0000 (12:41 -0400)
commit80af818dd618b18d8e4b3f629844190473f2bae2
treee3b354379e1d4de7ef04084e7696a9067a2b5132tree | snapshot
parent861f4fb9fe47f2aae31e44beebc8e925936c0367commit | 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.