Horton

Re: Change JOIN tutorial to focus more on explicit joins

Thomas Munro <thomas.munro@gmail.com>

View thread View on postgr.es
From: Thomas Munro <thomas.munro@gmail.com>
To: shammat@gmx.net, pgsql-docs@lists.postgresql.org
Date: 2020-05-20T21:56:02Z
Lists: pgsql-hackers, pgsql-docs 
On Thu, May 21, 2020 at 1:37 AM PG Doc comments form
<noreply@postgresql.org> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/12/tutorial-join.html
> Description:
>
> The tutorial about joins makes the following statement about the explicit
> JOIN operator:
>
> > This syntax is not as commonly used as the one above
>
> I think in 2020 this claim is no longer true, and I would love to see the
> manual prefer the "modern" explicit JOIN operator rather than sticking to
> the ancient implicit joins in the WHERE clause.

+1

The "new" syntax is 28 years old, from SQL 92.  I don't see too many
SQL 86 joins.  Would you like to write a documentation patch?

Commits

  1. doc: Prefer explicit JOIN syntax over old implicit syntax in tutorial

  2. doc: Change table alias names to lower case in tutorial chapter

  3. doc: Fix whitespace issue in PDF

  4. doc: Use tags consistently in the tutorial chapter