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 1ekCnN-0008KV-CC for pgsql-docs@arkaria.postgresql.org; Fri, 09 Feb 2018 17:49:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ekCnM-0008Hx-Et for pgsql-docs@arkaria.postgresql.org; Fri, 09 Feb 2018 17:49:08 +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.84_2) (envelope-from ) id 1ekCnM-0008Ho-9P for pgsql-docs@lists.postgresql.org; Fri, 09 Feb 2018 17:49:08 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ekCnI-0006dm-H8 for pgsql-docs@lists.postgresql.org; Fri, 09 Feb 2018 17:49:07 +0000 Content-Type: multipart/mixed; boundary="===============9167397683565419859==" MIME-Version: 1.0 Subject: Documentation of EXCEPT ALL may have a bug To: pgsql-docs@lists.postgresql.org From: =?utf-8?q?PG_Doc_comments_form?= Cc: jao@geophile.com Reply-To: jao@geophile.com, pgsql-docs@lists.postgresql.org Date: Fri, 09 Feb 2018 17:48:31 +0000 Message-ID: <151819851166.9466.6740951677204542727@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============9167397683565419859== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMC9zdGF0 aWMvcXVlcmllcy11bmlvbi5odG1sCkRlc2NyaXB0aW9uOgoKSSBiZWxpZXZlIHRoYXQgdGhlIGRv Y3VtZW50ZWQgYmVoYXZpb3Igb2YgRVhDRVBUIGlzIG5vdCBpbiBhZ3JlZW1lbnQNCndpdGggUG9z dGdyZXMgYmVoYXZpb3IgKEknbSB1c2luZyBQb3N0Z3JlcyA5LjUpLiBUaGUgZG9jdW1lbnRzIHNh eToNCg0KICAgIEVYQ0VQVCByZXR1cm5zIGFsbCByb3dzIHRoYXQgYXJlIGluIHRoZSByZXN1bHQg b2YgcXVlcnkxIGJ1dCBub3QNCiAgICBpbiB0aGUgcmVzdWx0IG9mIHF1ZXJ5Mi4gKFRoaXMgaXMg c29tZXRpbWVzIGNhbGxlZCB0aGUgZGlmZmVyZW5jZQ0KICAgIGJldHdlZW4gdHdvIHF1ZXJpZXMu KSBBZ2FpbiwgZHVwbGljYXRlcyBhcmUgZWxpbWluYXRlZCB1bmxlc3MNCiAgICBFWENFUFQgQUxM IGlzIHVzZWQuDQoNCkhlcmUgaXMgYSB0ZXN0IHNjcmlwdDoNCg0KICAgIGRyb3AgdGFibGUgaWYg ZXhpc3RzIHQ7DQogICAgZHJvcCB0YWJsZSBpZiBleGlzdHMgdTsNCiAgICANCiAgICBjcmVhdGUg dGFibGUgdCh4IGludCk7DQogICAgY3JlYXRlIHRhYmxlIHUoeCBpbnQpOw0KICAgIA0KICAgIGlu c2VydCBpbnRvIHQgdmFsdWVzICgxKSwgKDIpLCAoMiksICgzKSwgKDMpOw0KICAgIGluc2VydCBp bnRvIHUgdmFsdWVzICgxKSwgKDIpOw0KICAgIA0KICAgIHNlbGVjdCAqIGZyb20gdCBleGNlcHQg c2VsZWN0ICogZnJvbSB1Ow0KICAgIHNlbGVjdCAqIGZyb20gdCBleGNlcHQgYWxsIHNlbGVjdCAq IGZyb20gdTsNCg0KQW5kIGhlcmUgaXMgdGhlIG91dHB1dDoNCg0KICAgIERST1AgVEFCTEUNCiAg ICBEUk9QIFRBQkxFDQogICAgQ1JFQVRFIFRBQkxFDQogICAgQ1JFQVRFIFRBQkxFDQogICAgSU5T RVJUIDAgNQ0KICAgIElOU0VSVCAwIDINCiAgICANCiAgICAgeCANCiAgICAtLS0NCiAgICAgMw0K ICAgICgxIHJvdykNCiAgICANCiAgICAgeCANCiAgICAtLS0NCiAgICAgMw0KICAgICAzDQogICAg IDINCiAgICAoMyByb3dzKQ0KICAgIA0KVGhlIG91dHB1dCBmcm9tIEVYQ0VQVCBtYXRjaGVzIHRo ZSBkb2N1bWVudGVkIGJlaGF2aW9yLg0KDQpUaGUgb3V0cHV0IGZyb20gRVhDRVBUIEFMTCBtYWtl cyBzZW5zZSB0byBtZSwgYnV0IEkgdGhpbmsgaXQgaXMgYXQNCm9kZHMgd2l0aCB0aGUgZG9jdW1l bnRhdGlvbjogIkVYQ0VQVCByZXR1cm5zIGFsbCByb3dzIHRoYXQgYXJlIGluIHRoZQ0KcmVzdWx0 IG9mIHF1ZXJ5MSBidXQgbm90IGluIHRoZSByZXN1bHQgb2YgcXVlcnkyLiIgVGhpcyBnZW5lcmFs DQpzdGF0ZW1lbnQgaXMgdGhlbiBtb2RpZmllZCBieSB0aGUgZGlzY3Vzc2lvbiBvZiBFWENFUFQg QUxMLiBUaGF0IGZpcnN0DQpzZW50ZW5jZSBkb2VzIG5vdCBkZWFsIHdpdGggZHVwbGljYXRlcyBp biB0aGUgaW5wdXQgdGFibGVzLCBhbmQganVzdA0KZGlzY3Vzc2VzIHNldCBtZW1iZXJzaGlwLiBF YWNoIG9jY3VycmVuY2Ugb2YgKDMpIGluIHF1ZXJ5MSBpcw0KdGhlcmVmb3JlIGtlcHQuICBGb3Ig RVhDRVBULCB0aGUgZHVwbGljYXRlcyBhcmUgZWxpbWluYXRlZCAoeWllbGRpbmcNCnRoZSBvdXRw dXQgWzNdKSwgYW5kIEVYQ0VQVCBBTEwgc2hvdWxkIHRoZXJlZm9yZSB5aWVsZCBbMywgM10uICBJ biB0aGUNCkVYQ0VQVCBBTEwgY2FzZSwgYm90aCBvY2N1cnJlbmNlcyBvZiAoMikgaW4gcXVlcnkx IHNob3VsZCBiZQ0KZWxpbWluYXRlZCBieSB0aGUgb25lIG9jY3VycmVuY2UgaW4gcXVlcnkyLiBJ IHRoaW5rIHRoaXMgaXMgYSBmYWlyDQppbnRlcnByZXRhdGlvbiBiYXNlZCBvbiB0aGUgd29yZGlu Zy4NCg0KVG8gbWF0Y2ggdGhlIG9ic2VydmVkIGJlaGF2aW9yLCBJIHRoaW5rIHRoYXQgdGhlIGRl c2NyaXB0aW9uIG9mIEVYQ0VQVA0KQUxMIG5lZWRzIHRvIGJlIG1vZGlmaWVkIHRvIHNvbWV0aGlu ZyBsaWtlIHRoaXM6DQoNCkVYQ0VQVCBBTEwgcmV0dXJucyB0aG9zZSByb3dzIG9mIHF1ZXJ5MSBp biBleGNlc3Mgb2YgbWF0Y2hpbmcgcm93cyBpbg0KcXVlcnkyLCBhcyB3ZWxsIGFzIHJvd3Mgb2Yg cXVlcnkxIHRoYXQgaGF2ZSBubyBtYXRjaCBpbiBxdWVyeTIuCg== --===============9167397683565419859==--