Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: dirk(dot)lattermann(at)leanix(dot)net
Subject: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT
Date: 2018-03-15 10:18:54
Message-ID: 152110913499.1223.7026776990975251345@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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_statement UNION [ ALL | DISTINCT ] select_statement

which uses boldface "select_statement" instead of boldface "select" as in
the synopsis. This is confusing.

It would be great if the boldface "select" in the synopsis could be better
defined.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2018-03-15 13:55:09 Problems with pg_upgrade under Windows
Previous Message PG Doc comments form 2018-03-12 23:28:53 Can we only add values to enums?