pgsql: Improve documentation's description of JOIN clauses.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve documentation's description of JOIN clauses.
Date: 2014-11-19 21:01:11
Message-ID: E1XrCND-0005nZ-JD@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve documentation's description of JOIN clauses.

In bug #12000, Andreas Kunert complained that the documentation was
misleading in saying "FROM T1 CROSS JOIN T2 is equivalent to FROM T1, T2".
That's correct as far as it goes, but the equivalence doesn't hold when
you consider three or more tables, since JOIN binds more tightly than
comma. I added a <note> to explain this, and ended up rearranging some
of the existing text so that the note would make sense in context.

In passing, rewrite the description of JOIN USING, which was unnecessarily
vague, and hadn't been helped any by somebody's reliance on markup as a
substitute for clear writing. (Mostly this involved reintroducing a
concrete example that was unaccountably removed by commit 032f3b7e166cfa28.)

Back-patch to all supported branches.

Branch
------
REL9_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/0632eff4389a2682c49db7fbe16968bb076060a5

Modified Files
--------------
doc/src/sgml/queries.sgml | 154 ++++++++++++++++++++++++++++-----------------
1 file changed, 98 insertions(+), 56 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2014-11-20 03:23:35 pgsql: Fix suggested layout for PGXS makefile
Previous Message Heikki Linnakangas 2014-11-19 17:59:29 pgsql: Add test cases for indexam operations not currently covered.