pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedINNER JOIN syntax is not commonly used?
5+ messages / 5 participants
[nested] [flat]
* INNER JOIN syntax is not commonly used?
@ 2021-03-07 09:33 PG Doc comments form <noreply@postgresql.org>
0 siblings, 2 replies; 5+ messages in thread
From: PG Doc comments form @ 2021-03-07 09:33 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: max1@inbox.ru
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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: INNER JOIN syntax is not commonly used?
@ 2021-03-07 11:42 Andrew Grillet <andrew@grillet.co.uk>
parent: PG Doc comments form <noreply@postgresql.org>
1 sibling, 0 replies; 5+ messages in thread
From: Andrew Grillet @ 2021-03-07 11:42 UTC (permalink / raw)
To: max1@inbox.ru, Pg Docs <pgsql-docs@lists.postgresql.org>
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:
>
> 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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: INNER JOIN syntax is not commonly used?
@ 2021-03-07 11:45 Vik Fearing <vik@postgresfriends.org>
parent: PG Doc comments form <noreply@postgresql.org>
1 sibling, 1 reply; 5+ messages in thread
From: Vik Fearing @ 2021-03-07 11:45 UTC (permalink / raw)
To: max1@inbox.ru; pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: INNER JOIN syntax is not commonly used?
@ 2021-03-07 12:05 Pavel Stehule <pavel.stehule@gmail.com>
parent: Vik Fearing <vik@postgresfriends.org>
0 siblings, 1 reply; 5+ messages in thread
From: Pavel Stehule @ 2021-03-07 12:05 UTC (permalink / raw)
To: Vik Fearing <vik@postgresfriends.org>; +Cc: max1@inbox.ru, Pg Docs <pgsql-docs@lists.postgresql.org>
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.
--
> Vik Fearing
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: INNER JOIN syntax is not commonly used?
@ 2021-03-07 14:14 David G. Johnston <david.g.johnston@gmail.com>
parent: Pavel Stehule <pavel.stehule@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: David G. Johnston @ 2021-03-07 14:14 UTC (permalink / raw)
To: Pavel Stehule <pavel.stehule@gmail.com>; +Cc: Vik Fearing <vik@postgresfriends.org>; max1@inbox.ru, Pg Docs <pgsql-docs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2021-03-07 14:14 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-07 09:33 INNER JOIN syntax is not commonly used? PG Doc comments form <noreply@postgresql.org>
2021-03-07 11:42 ` Andrew Grillet <andrew@grillet.co.uk>
2021-03-07 11:45 ` Vik Fearing <vik@postgresfriends.org>
2021-03-07 12:05 ` Pavel Stehule <pavel.stehule@gmail.com>
2021-03-07 14:14 ` David G. Johnston <david.g.johnston@gmail.com>
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