[COMMITTERS] pgsql: Doc: clarify description of degenerate NATURAL joins.

2017-07-20 Thread Tom Lane
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=xmkaxcdf4ykkpm...@mail.gmail.com

Branch
--
REL9_2_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/80af818dd618b18d8e4b3f629844190473f2bae2

Modified Files
--
doc/src/sgml/queries.sgml| 4 ++--
doc/src/sgml/ref/select.sgml | 7 +--
2 files changed, 7 insertions(+), 4 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Doc: clarify description of degenerate NATURAL joins.

2017-07-20 Thread Tom Lane
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=xmkaxcdf4ykkpm...@mail.gmail.com

Branch
--
REL9_4_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/769eaef7600b0cc63bdc488428c4e01902261a73

Modified Files
--
doc/src/sgml/queries.sgml| 4 ++--
doc/src/sgml/ref/select.sgml | 7 +--
2 files changed, 7 insertions(+), 4 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Doc: clarify description of degenerate NATURAL joins.

2017-07-20 Thread Tom Lane
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=xmkaxcdf4ykkpm...@mail.gmail.com

Branch
--
REL9_3_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/a6088e1f5a58e47ee6f207ec13c67773852df970

Modified Files
--
doc/src/sgml/queries.sgml| 4 ++--
doc/src/sgml/ref/select.sgml | 7 +--
2 files changed, 7 insertions(+), 4 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Doc: clarify description of degenerate NATURAL joins.

2017-07-20 Thread Tom Lane
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=xmkaxcdf4ykkpm...@mail.gmail.com

Branch
--
REL9_5_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/315ca7ffb90939af8b3e08f5a2a6afbfc6d89c7d

Modified Files
--
doc/src/sgml/queries.sgml| 4 ++--
doc/src/sgml/ref/select.sgml | 7 +--
2 files changed, 7 insertions(+), 4 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Doc: clarify description of degenerate NATURAL joins.

2017-07-20 Thread Tom Lane
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=xmkaxcdf4ykkpm...@mail.gmail.com

Branch
--
REL9_6_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/5512427b19e79ac95535e7c942bd479db807f7be

Modified Files
--
doc/src/sgml/queries.sgml| 4 ++--
doc/src/sgml/ref/select.sgml | 7 +--
2 files changed, 7 insertions(+), 4 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Doc: clarify description of degenerate NATURAL joins.

2017-07-20 Thread Tom Lane
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=xmkaxcdf4ykkpm...@mail.gmail.com

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/ed3dc224e5aabd3cb0a5c348107f973fe5b10b0d

Modified Files
--
doc/src/sgml/queries.sgml| 4 ++--
doc/src/sgml/ref/select.sgml | 7 +--
2 files changed, 7 insertions(+), 4 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers