INNER JOIN syntax is not commonly used?
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 (weather.city = cities.name);
And after that it says the following:
"This syntax is not as commonly used as the one above, "
So, this documentation claims that the INNER JOIN syntax is not as common as
WHERE syntax.
Is this really the case?
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
<noreply@postgresql.org> wrote:
Show quoted text
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 (weather.city = cities.name);And after that it says the following:
"This syntax is not as commonly used as the one above, "So, this documentation claims that the INNER JOIN syntax is not as common as
WHERE syntax.
Is this really the case?
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 JOIN syntax:
SELECT *
FROM weather INNER JOIN cities ON (weather.city = cities.name);And after that it says the following:
"This syntax is not as commonly used as the one above, "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 <table
reference list> syntax. In my experience, the <joined table> syntax is
much more common. I vote to change the wording on that page.
--
Vik Fearing
ne 7. 3. 2021 v 12:45 odesílatel Vik Fearing <vik@postgresfriends.org>
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 syntax to join tables.
After that it shows an example of the INNER JOIN syntax:
SELECT *
FROM weather INNER JOIN cities ON (weather.city = cities.name);And after that it says the following:
"This syntax is not as commonly used as the one above, "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 <table
reference list> syntax. In my experience, the <joined table> syntax is
much more common. I vote to change the wording on that page.
+1, modern syntax is more common today.
--
Show quoted text
Vik Fearing
On Sun, Mar 7, 2021 at 5:06 AM Pavel Stehule <pavel.stehule@gmail.com>
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 <table
reference list> syntax. In my experience, the <joined table> syntax is
much more common. I vote to change the wording on that page.+1, modern syntax is more common today.
There is already a patch in the commitfest doing this.
https://commitfest.postgresql.org/32/2652/
David J.