Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

On Mon, Apr 2, 2018 at 08:21:45PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > Based on this discussion, I have developed the attached patch which > > tries to clarify the behavior without adding complexity. > > I don't think this is an improvement, really ... in

Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

Bruce Momjian writes: > Based on this discussion, I have developed the attached patch which > tries to clarify the behavior without adding complexity. I don't think this is an improvement, really ... in particular, it makes the not self-contained, which is pretty horrible for

Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

On Sun, Mar 18, 2018 at 02:28:26PM -0700, David G. Johnston wrote: > As a first step we could do something like: > > ​basic_select_statement is: > ​ > > SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ] >     [ * | expression [ [ AS ] output_name ] [, ...] ] >     [ FROM

Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

As a first step we could do something like: ​basic_select_statement is: ​ > SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ] > [ * | expression [ [ AS ] output_name ] [, ...] ] > [ FROM from_item [, ...] ] > [ WHERE condition ] > [ GROUP BY grouping_element [, ...] ] >

Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

2018-03-16 2:17 GMT-03:00 Tom Lane : > Euler Taveira writes: >> 2018-03-15 7:18 GMT-03:00 PG Doc comments form : >>> The SYNOPSIS section of the "SELECT" SQL command contains the line >>> [ { UNION | INTERSECT | EXCEPT } [ ALL |

Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

2018-03-15 7:18 GMT-03:00 PG Doc comments form : > 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 >

Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

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