]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c2bbec9) | 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:37 +0000 (12:41 -0400)
commit315ca7ffb90939af8b3e08f5a2a6afbfc6d89c7d
tree5baa18a8c67c065e91844e94f910d32fb4b715f7tree | snapshot
parentc2bbec9f2b3672f57be27e20f26db141ab430da8commit | 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