MIME-Version: 1.0
In-Reply-To: <152110913499.1223.7026776990975251345@wrigleys.postgresql.org>
References: <152110913499.1223.7026776990975251345@wrigleys.postgresql.org>
From: Euler Taveira <euler@timbira.com.br>
Date: Fri, 16 Mar 2018 01:02:13 -0300
Message-ID: 
 <CAHE3wgiaV1YyQ6-v12R4bzmQoUc_5E3hBupKxHTzLXg2TOsh-g@mail.gmail.com>
Subject: Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT
To: dirk.lattermann@leanix.net, pgsql-docs@lists.postgresql.org
Content-Type: multipart/mixed; boundary="0000000000006d223105677fac0e"
Precedence: bulk

--0000000000006d223105677fac0e
Content-Type: text/plain; charset="UTF-8"

2018-03-15 7:18 GMT-03:00 PG Doc comments form <noreply@postgresql.org>:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/static/sql-select.html
> Description:
>
> The SYNOPSIS section of the "SELECT" SQL command contains the line
>
> [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] select ]
>
> (with a boldface "select"), but it is not clear what is meant by that
> "select". Further down the page, in the "UNION clause" section (and also
> INTERSECTION or EXCEPT), it is written:
>
"select" is defined as a sub-select that can appear in the FROM clause
(see the From Clause section).

> select_statement UNION [ ALL | DISTINCT ] select_statement
>
> which uses boldface "select_statement" instead of boldface "select" as in
> the synopsis. This is confusing.
>
It is a bug in the synopsis. UNION et al cannot contain some elements
(such as ORDER BY) that is allowed for a sub-select. The attached
patch replace "select" with the correct element ("select_statement").


-- 
   Euler Taveira                                   Timbira -
http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

--0000000000006d223105677fac0e
Content-Type: text/x-patch; charset="US-ASCII"; name="doc.diff"
Content-Disposition: attachment; filename="doc.diff"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_jetez8340

ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvc2VsZWN0LnNnbWwgYi9kb2Mvc3JjL3NnbWwv
cmVmL3NlbGVjdC5zZ21sCmluZGV4IGI1ZDNkM2EuLjVhY2Q3NDkgMTAwNjQ0Ci0tLSBhL2RvYy9z
cmMvc2dtbC9yZWYvc2VsZWN0LnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9zZWxlY3Quc2dt
bApAQCAtNDAsNyArNDAsNyBAQCBTRUxFQ1QgWyBBTEwgfCBESVNUSU5DVCBbIE9OICggPHJlcGxh
Y2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPmV4cHJlc3Npb248L3JlcGxhYwogICAgIFsgR1JPVVAg
QlkgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPmdyb3VwaW5nX2VsZW1lbnQ8L3JlcGxh
Y2VhYmxlPiBbLCAuLi5dIF0KICAgICBbIEhBVklORyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFt
ZXRlciI+Y29uZGl0aW9uPC9yZXBsYWNlYWJsZT4gWywgLi4uXSBdCiAgICAgWyBXSU5ET1cgPHJl
cGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPndpbmRvd19uYW1lPC9yZXBsYWNlYWJsZT4gQVMg
KCA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+d2luZG93X2RlZmluaXRpb248L3JlcGxh
Y2VhYmxlPiApIFssIC4uLl0gXQotICAgIFsgeyBVTklPTiB8IElOVEVSU0VDVCB8IEVYQ0VQVCB9
IFsgQUxMIHwgRElTVElOQ1QgXSA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+c2VsZWN0
PC9yZXBsYWNlYWJsZT4gXQorICAgIFsgeyBVTklPTiB8IElOVEVSU0VDVCB8IEVYQ0VQVCB9IFsg
QUxMIHwgRElTVElOQ1QgXSA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+c2VsZWN0X3N0
YXRlbWVudDwvcmVwbGFjZWFibGU+IF0KICAgICBbIE9SREVSIEJZIDxyZXBsYWNlYWJsZSBjbGFz
cz0icGFyYW1ldGVyIj5leHByZXNzaW9uPC9yZXBsYWNlYWJsZT4gWyBBU0MgfCBERVNDIHwgVVNJ
TkcgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPm9wZXJhdG9yPC9yZXBsYWNlYWJsZT4g
XSBbIE5VTExTIHsgRklSU1QgfCBMQVNUIH0gXSBbLCAuLi5dIF0KICAgICBbIExJTUlUIHsgPHJl
cGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPmNvdW50PC9yZXBsYWNlYWJsZT4gfCBBTEwgfSBd
CiAgICAgWyBPRkZTRVQgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPnN0YXJ0PC9yZXBs
YWNlYWJsZT4gWyBST1cgfCBST1dTIF0gXQo=
--0000000000006d223105677fac0e--