Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f3Lvd-0001uM-JO for pgsql-docs@arkaria.postgresql.org; Tue, 03 Apr 2018 13:24:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f3Lvc-00083o-FC for pgsql-docs@arkaria.postgresql.org; Tue, 03 Apr 2018 13:24:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f3Lvc-00083d-9y for pgsql-docs@lists.postgresql.org; Tue, 03 Apr 2018 13:24:48 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1f3LvY-0007PV-OT for pgsql-docs@lists.postgresql.org; Tue, 03 Apr 2018 13:24:47 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1f3LvT-0003DT-Nc; Tue, 03 Apr 2018 09:24:39 -0400 Date: Tue, 3 Apr 2018 09:24:39 -0400 From: Bruce Momjian To: Tom Lane Cc: "David G. Johnston" , Euler Taveira , dirk.lattermann@leanix.net, pgsql-docs@lists.postgresql.org Subject: Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT Message-ID: <20180403132439.GA11837@momjian.us> References: <152110913499.1223.7026776990975251345@wrigleys.postgresql.org> <28115.1521177420@sss.pgh.pa.us> <20180403000521.GA12774@momjian.us> <32505.1522714905@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <32505.1522714905@sss.pgh.pa.us> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 particular, it > makes the not self-contained, which is pretty horrible > for psql's help. Well, we know we are limited in how much precision we can add without losing clarity. I don't have any new ideas so we will just have to keep what we have, though I do think mine was an improvement in enough areas to warrant it. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +