Documentation Issue?
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-join.html
Description:
The documentation at https://www.postgresql.org/docs/12/tutorial-join.html
shows this query:
SELECT *
FROM weather, cities
WHERE city = name;
And then presents the following query as "an alternate form" that is "not as
commonly used as the one above":
SELECT *
FROM weather INNER JOIN cities ON (weather.city = cities.name);
Isn't that backwards? Isn't the first query the old ANSI-89 syntax?
Shouldn't we be using then newer "INNER JOIN" syntax?
On Wed, Jul 15, 2020 at 5:25 AM PG Doc comments form
<noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-join.html
Description:The documentation at https://www.postgresql.org/docs/12/tutorial-join.html
shows this query:SELECT *
FROM weather, cities
WHERE city = name;And then presents the following query as "an alternate form" that is "not as
commonly used as the one above":SELECT *
FROM weather INNER JOIN cities ON (weather.city = cities.name);Isn't that backwards? Isn't the first query the old ANSI-89 syntax?
Shouldn't we be using then newer "INNER JOIN" syntax?
+1
Would you like to review the patch proposed over here?
/messages/by-id/158996922318.7035.10603922579567326239@wrigleys.postgresql.org