From: Vik Fearing <vik@postgresfriends.org>
To: max1@inbox.ru
To: pgsql-docs@lists.postgresql.org
Subject: Re: INNER JOIN syntax is not commonly used?
Date: Sun, 7 Mar 2021 12:45:46 +0100
Message-ID: <b5bdc2dc-ceb4-52e9-2fc1-83b771829a2b@postgresfriends.org> (raw)
In-Reply-To: <161510962276.1050.10968048440449352120@wrigleys.postgresql.org>
References: <161510962276.1050.10968048440449352120@wrigleys.postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: vik@postgresfriends.org, max1@inbox.ru, pgsql-docs@lists.postgresql.org
Subject: Re: INNER JOIN syntax is not commonly used?
In-Reply-To: <b5bdc2dc-ceb4-52e9-2fc1-83b771829a2b@postgresfriends.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox