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?