Thread: 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? https://www.postgresql.org/message-id/flat/158996922318.7035.10603922579567326239%40wrigleys.postgresql.org