From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Jürgen Purtz <juergen(at)purtz(dot)de>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Thomas Kellerer <shammat(at)gmx(dot)net>, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Change JOIN tutorial to focus more on explicit joins |
Date: | 2020-10-22 16:31:07 |
Message-ID: | CAFj8pRDzb7cj22vvm5ebL7hqFVbw0=Q8DDZzpFnse2Qaxz1SYA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
čt 22. 10. 2020 v 18:27 odesílatel David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> napsal:
> On Thu, Oct 22, 2020 at 8:14 AM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jürgen Purtz | 2020-10-23 09:14:07 | Re: Change JOIN tutorial to focus more on explicit joins |
Previous Message | David G. Johnston | 2020-10-22 16:27:08 | Re: Change JOIN tutorial to focus more on explicit joins |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2020-10-22 17:11:58 | Re: Deleting older versions in unique indexes to avoid page splits |
Previous Message | David G. Johnston | 2020-10-22 16:27:08 | Re: Change JOIN tutorial to focus more on explicit joins |