Re: Change JOIN tutorial to focus more on explicit joins

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Jürgen Purtz <juergen(at)purtz(dot)de>
Cc: shammat(at)gmx(dot)net, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Change JOIN tutorial to focus more on explicit joins
Date: 2020-07-17 23:48:40
Message-ID: CA+hUKGKfdRQtqJ_m6GRv5ALMJ91nQw4n0hh5wBkPmmk+3J=diw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

On Wed, May 27, 2020 at 8:29 PM Jürgen Purtz <juergen(at)purtz(dot)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.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Jeff Davis 2020-07-18 00:13:15 Re: Default setting for enable_hashagg_disk
Previous Message Jürgen Purtz 2020-07-17 09:32:50 Re: Additional Chapter for Tutorial

Browse pgsql-hackers by date

  From Date Subject
Next Message Chapman Flack 2020-07-18 00:03:23 pg_ctl behavior on Windows
Previous Message Justin Pryzby 2020-07-17 22:32:36 Re: expose parallel leader in CSV and log_line_prefix