From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Vik Fearing <vik(at)postgresfriends(dot)org> |
Cc: | max1(at)inbox(dot)ru, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: INNER JOIN syntax is not commonly used? |
Date: | 2021-03-07 12:05:43 |
Message-ID: | CAFj8pRAzfrnEj=d3EPm39rOjm77eQrtjZaJ4Ci=NMuDk8ZVTBw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
ne 7. 3. 2021 v 12:45 odesílatel Vik Fearing <vik(at)postgresfriends(dot)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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | PG Doc comments form | 2021-03-07 13:32:08 | advanced.sql tutorial script |
Previous Message | Vik Fearing | 2021-03-07 11:45:46 | Re: INNER JOIN syntax is not commonly used? |