Re: Change JOIN tutorial to focus more on explicit joins

2020-10-23 Thread Pavel Stehule
pá 23. 10. 2020 v 11:14 odesílatel Jürgen Purtz napsal: > On 22.10.20 17:14, Pavel Stehule wrote: > > > > Why do you use parenthesis for ON clause? It is useless. SQL is not C > > or JAVA. > > > Two more general answers: > - Why do people use tabs, spaces, and newlines to format their code even

Re: Change JOIN tutorial to focus more on explicit joins

2020-10-23 Thread Jürgen Purtz
On 22.10.20 17:14, Pavel Stehule wrote: Why do you use parenthesis for ON clause?  It is useless. SQL is not C or JAVA. Two more general answers: - Why do people use tabs, spaces, and newlines to format their code even though it's not necessary? SQL is a language to develop applications. A

Re: Change JOIN tutorial to focus more on explicit joins

2020-10-22 Thread Pavel Stehule
čt 22. 10. 2020 v 18:27 odesílatel David G. Johnston < david.g.johns...@gmail.com> napsal: > On Thu, Oct 22, 2020 at 8:14 AM Pavel Stehule > 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

Re: Change JOIN tutorial to focus more on explicit joins

2020-10-22 Thread David G. Johnston
On Thu, Oct 22, 2020 at 8:14 AM Pavel Stehule 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?

Re: Change JOIN tutorial to focus more on explicit joins

2020-10-22 Thread Pavel Stehule
čt 22. 10. 2020 v 15:32 odesílatel Jürgen Purtz napsal: > On 22.10.20 01:40, David G. Johnston wrote: > > On Fri, Sep 4, 2020 at 2:36 AM Jürgen Purtz wrote: > >> On 04.09.20 08:52, Peter Eisentraut wrote: >> > >> > For the remaining patch I have a couple of concerns: >> > > This patch should not

Re: Change JOIN tutorial to focus more on explicit joins

2020-10-22 Thread Jürgen Purtz
On 22.10.20 01:40, David G. Johnston wrote: On Fri, Sep 4, 2020 at 2:36 AM Jürgen Purtz > wrote: On 04.09.20 08:52, Peter Eisentraut wrote: > > For the remaining patch I have a couple of concerns: This patch should not be changing the formatting choices for

Re: Change JOIN tutorial to focus more on explicit joins

2020-10-21 Thread David G. Johnston
On Fri, Sep 4, 2020 at 2:36 AM Jürgen Purtz wrote: > On 04.09.20 08:52, Peter Eisentraut wrote: > > > > For the remaining patch I have a couple of concerns: > This patch should not be changing the formatting choices for these queries, just the addition of a JOIN clause and modification of the WH

Re: Change JOIN tutorial to focus more on explicit joins

2020-09-04 Thread Jürgen Purtz
On 04.09.20 08:52, Peter Eisentraut wrote: For the remaining patch I have a couple of concerns: >  >   Attempt to determine the semantics of this query when the > - WHERE clause is omitted. > + ON clause is omitted. >  > This no longer works. Ok, but I don't have a

Re: Change JOIN tutorial to focus more on explicit joins

2020-09-03 Thread Peter Eisentraut
On 2020-05-27 10:29, Jürgen Purtz wrote: 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 and tags - shifts definitions outside of to get a better rendering

Re: Change JOIN tutorial to focus more on explicit joins

2020-07-17 Thread Thomas Munro
On Wed, May 27, 2020 at 8:29 PM Jürgen Purtz 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 > th

Re: Change JOIN tutorial to focus more on explicit joins

2020-05-27 Thread Jürgen Purtz
On 20.05.20 23:56, Thomas Munro wrote: On Thu, May 21, 2020 at 1:37 AM PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-join.html Description: The tutorial about joins makes the following statemen

Re: Change JOIN tutorial to focus more on explicit joins

2020-05-20 Thread Thomas Munro
On Thu, May 21, 2020 at 1:37 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/tutorial-join.html > Description: > > The tutorial about joins makes the following statement about the explicit > JOIN oper

Change JOIN tutorial to focus more on explicit joins

2020-05-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-join.html Description: The tutorial about joins makes the following statement about the explicit JOIN operator: > This syntax is not as commonly used as the one above I think in