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: Jürgen Purtz <juergen@purtz.de>
Cc: shammat@gmx.net, pgsql-docs@lists.postgresql.org
Date: 2020-07-17T23:48:40Z
Lists: pgsql-hackers, pgsql-docs 
On Wed, May 27, 2020 at 8:29 PM Jürgen 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ürgen,

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

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