MIME-Version: 1.0
References: <158996922318.7035.10603922579567326239@wrigleys.postgresql.org>
 <CA+hUKG+K+75fo+cKA2Vb_kmFsxX=9qgi48_dLqPyShfhFdSKMw@mail.gmail.com>
 <dfacbc6e-e4c2-3e90-3529-4515559abb41@purtz.de>
In-Reply-To: <dfacbc6e-e4c2-3e90-3529-4515559abb41@purtz.de>
From: Thomas Munro <thomas.munro@gmail.com>
Date: Sat, 18 Jul 2020 11:48:40 +1200
Message-ID: 
 <CA+hUKGKfdRQtqJ_m6GRv5ALMJ91nQw4n0hh5wBkPmmk+3J=diw@mail.gmail.com>
Subject: Re: Change JOIN tutorial to focus more on explicit joins
To: =?UTF-8?Q?J=C3=BCrgen_Purtz?= <juergen@purtz.de>
Cc: shammat@gmx.net, pgsql-docs@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

On Wed, May 27, 2020 at 8:29 PM J=C3=BCrgen Purtz <juergen@purtz.de> wrote:
> > 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?
> >
> >
> The attached patch
>
> - prefers the explicit join-syntax over the implicit one and explains
> the keywords of the explicit syntax
>
> - uses a more accurate definition of 'join'
>
> - separates <programlisting> and <screen> tags
>
> - shifts <indexterm> definitions outside of <para> to get a better
> rendering in PDF
>
> - adds a note concerning IDs and foreign keys

Hi J=C3=BCrgen,

Please add to the commitfest app, so we don't lose track of it.