advanced.sql tutorial script

2021-03-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-advanced-intro.html Description: I built tutorial files according to instructions from the section 2.1. And I found that the script advanced.sql covers only the section "3.6. Inhe

Re: make tutorial 13.2

2021-03-07 Thread Tom Lane
PG Doc comments form writes: > I have a binary distribution version 13.2, installed from the Postgres yum > repository, on Fedora 33. > So, I downloaded the source code from here: > https://www.postgresql.org/ftp/source/v13.2/ > And tried to build according to the instruction: > [max@max-home tut

Re: INNER JOIN syntax is not commonly used?

2021-03-07 Thread David G. Johnston
On Sun, Mar 7, 2021 at 5:06 AM Pavel Stehule wrote: > >> > So, this documentation claims that the INNER JOIN syntax is not as >> common as >> > WHERE syntax. >> > Is this really the case? >> >> I don't remember the last time I saw a new query use the > reference list> syntax. In my experience, t

Re: INNER JOIN syntax is not commonly used?

2021-03-07 Thread Pavel Stehule
ne 7. 3. 2021 v 12:45 odesílatel Vik Fearing napsal: > On 3/7/21 10:33 AM, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/13/tutorial-join.html > > Description: > > > > This page shows a WHERE synta

Re: INNER JOIN syntax is not commonly used?

2021-03-07 Thread Vik Fearing
On 3/7/21 10:33 AM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/tutorial-join.html > Description: > > This page shows a WHERE syntax to join tables. > > After that it shows an example of the INNER

Re: INNER JOIN syntax is not commonly used?

2021-03-07 Thread Andrew Grillet
I think it is less commonly used by new users. In my experience, the INNER JOIN syntax is preferred by more experiences users. On Sun, 7 Mar 2021 at 10:44, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs

INNER JOIN syntax is not commonly used?

2021-03-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-join.html Description: This page shows a WHERE syntax to join tables. After that it shows an example of the INNER JOIN syntax: SELECT * FROM weather INNER JOIN cities ON (wea

make tutorial 13.2

2021-03-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-sql-intro.html Description: https://www.postgresql.org/docs/13/tutorial-sql-intro.html This page tells how to make tutorial files: $ cd .../src/tutorial $ make I have a binary di