MIME-Version: 1.0
References: <158996922318.7035.10603922579567326239@wrigleys.postgresql.org>
In-Reply-To: <158996922318.7035.10603922579567326239@wrigleys.postgresql.org>
From: Thomas Munro <thomas.munro@gmail.com>
Date: Thu, 21 May 2020 09:56:02 +1200
Message-ID: 
 <CA+hUKG+K+75fo+cKA2Vb_kmFsxX=9qgi48_dLqPyShfhFdSKMw@mail.gmail.com>
Subject: Re: Change JOIN tutorial to focus more on explicit joins
To: shammat@gmx.net, pgsql-docs@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Precedence: bulk

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?