Re: exceptions

2020-10-22 Thread Jürgen Purtz
On 21.10.20 18:17, Tom Lane wrote: PG Doc comments form writes: Description: 02000 no_data should read no_data_found Looks correct as stated to me. plpgsql's ERRCODE_NO_DATA_FOUND (P0002) is a different animal. regards, tom lane Yes, our documentation correlates

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-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 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 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