| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Vik Fearing <vik(at)postgresfriends(dot)org>, 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 14:14:07 |
| Message-ID: | CAKFQuwZV4oM94_uodcEKPypDb8ohXBTfPkODvMF8bJiDRv5kaA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Sun, Mar 7, 2021 at 5:06 AM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-03-07 16:42:52 | Re: make tutorial 13.2 |
| Previous Message | PG Doc comments form | 2021-03-07 13:32:08 | advanced.sql tutorial script |