Re: Change JOIN tutorial to focus more on explicit joins

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Change JOIN tutorial to focus more on explicit joins
Дата
Msg-id CAKFQuwY5NSAAmFumosKPgm+804YGZsqm=pC1NSc1dGDCRBGE4A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Change JOIN tutorial to focus more on explicit joins  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Change JOIN tutorial to focus more on explicit joins
Список 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.

В списке pgsql-docs по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Change JOIN tutorial to focus more on explicit joins
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Change JOIN tutorial to focus more on explicit joins