public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Pavel Stehule <[email protected]>
Cc: Jürgen Purtz <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: Thomas Kellerer <[email protected]>
Cc: Pg Docs <[email protected]>
Subject: Re: Change JOIN tutorial to focus more on explicit joins
Date: Thu, 22 Oct 2020 09:27:08 -0700
Message-ID: <CAKFQuwY5NSAAmFumosKPgm+804YGZsqm=pC1NSc1dGDCRBGE4A@mail.gmail.com> (raw)
In-Reply-To: <CAFj8pRBEFAq_8EMy1btfUAzfvLOa_9-h8vYwzcAh1V_ufqykVw@mail.gmail.com>
References: <[email protected]>
<CA+hUKG+K+75fo+cKA2Vb_kmFsxX=9qgi48_dLqPyShfhFdSKMw@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<CAKFQuwZY5EqtMH_9SzTG=wSxq14m3FuwqPNDeeyK=Z6JO5-vUw@mail.gmail.com>
<[email protected]>
<CAFj8pRBEFAq_8EMy1btfUAzfvLOa_9-h8vYwzcAh1V_ufqykVw@mail.gmail.com>
On Thu, Oct 22, 2020 at 8:14 AM Pavel Stehule <[email protected]>
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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Change JOIN tutorial to focus more on explicit joins
In-Reply-To: <CAKFQuwY5NSAAmFumosKPgm+804YGZsqm=pC1NSc1dGDCRBGE4A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox