Horton

Re: Change JOIN tutorial to focus more on explicit joins

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Jürgen Purtz <juergen@purtz.de>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Thomas Munro <thomas.munro@gmail.com>, Thomas Kellerer <shammat@gmx.net>, Pg Docs <pgsql-docs@lists.postgresql.org>
Date: 2020-10-22T16:27:08Z
Lists: pgsql-hackers, pgsql-docs 
On Thu, Oct 22, 2020 at 8:14 AM Pavel Stehule <pavel.stehule@gmail.com>
wrote:

> Why do you use parenthesis for ON clause?  It is useless. SQL is not C or
> JAVA.
>
>
At this point in my career it's just a personal habit.  I never programmed
C, done most of my development in Java so maybe that's a subconscious
influence?

I suspect it is partly because I seldom need to use "ON" but instead join
with "USING" which does require the parentheses, so when I need to use ON I
just keep them.

I agree they are unnecessary in the example and should be removed to be
consistent.

David J.

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