Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cPZX4-00082c-LY for pgsql-docs@arkaria.postgresql.org; Fri, 06 Jan 2017 18:46:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cPZX4-00044S-8k for pgsql-docs@arkaria.postgresql.org; Fri, 06 Jan 2017 18:46:30 +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 1cOwZD-0008N4-OM for pgsql-docs@postgresql.org; Thu, 05 Jan 2017 01:10:07 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cOwZ9-0001mB-Ab for pgsql-docs@postgresql.org; Thu, 05 Jan 2017 01:10:06 +0000 MIME-Version: 1.0 Subject: I notice Postgresql 'HAVING' doesn't work. To: pgsql-docs@postgresql.org From: nnj@riseup.net Date: Thu, 05 Jan 2017 01:09:04 +0000 Message-ID: <20170105010904.10139.25730@wrigleys.postgresql.org> X-Pg-Spam-Score: -1.9 (-) Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4g bG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9z dGdyZXNxbC5vcmcvZG9jcy85LjUvc3RhdGljL3R1dG9yaWFsLWFnZy5odG1s CkRlc2NyaXB0aW9uOgoKRm9sbG93aW5nIHRoaXMgdHV0b3JpYWwgVGhlIE5l c3RlZCBTZXQgTW9kZWwgb24KaHR0cDovL21pa2VoaWxseWVyLmNvbS9hcnRp Y2xlcy9tYW5hZ2luZy1oaWVyYXJjaGljYWwtZGF0YS1pbi1teXNxbC8NCiAg DQoNClNlY3Rpb246IERlcHRoIG9mIGEgU3ViLVRyZWUuDQpTRUxFQ1Qgbm9k ZS5uYW1lLCAoQ09VTlQocGFyZW50Lm5hbWUpIC0gKHN1Yl90cmVlLmRlcHRo ICsgMSkpIEFTIGRlcHRoDQpGUk9NIG5lc3RlZF9jYXRlZ29yeSBBUyBub2Rl LA0KICAgICAgICBuZXN0ZWRfY2F0ZWdvcnkgQVMgcGFyZW50LA0KICAgICAg ICBuZXN0ZWRfY2F0ZWdvcnkgQVMgc3ViX3BhcmVudCwNCiAgICAgICAgKA0K ICAgICAgICAgICAgICAgIFNFTEVDVCBub2RlLm5hbWUsIChDT1VOVChwYXJl bnQubmFtZSkgLSAxKSBBUyBkZXB0aA0KICAgICAgICAgICAgICAgIEZST00g bmVzdGVkX2NhdGVnb3J5IEFTIG5vZGUsDQogICAgICAgICAgICAgICAgbmVz dGVkX2NhdGVnb3J5IEFTIHBhcmVudA0KICAgICAgICAgICAgICAgIFdIRVJF IG5vZGUubGZ0IEJFVFdFRU4gcGFyZW50LmxmdCBBTkQgcGFyZW50LnJndA0K ICAgICAgICAgICAgICAgIEFORCBub2RlLm5hbWUgPSAmIzM5O1BPUlRBQkxF IEVMRUNUUk9OSUNTJiMzOTsNCiAgICAgICAgICAgICAgICBHUk9VUCBCWSBu b2RlLm5hbWUsIG5vZGUubGZ0DQogICAgICAgICAgICAgICAgT1JERVIgQlkg bm9kZS5sZnQNCiAgICAgICAgKUFTIHN1Yl90cmVlDQpXSEVSRSBub2RlLmxm dCBCRVRXRUVOIHBhcmVudC5sZnQgQU5EIHBhcmVudC5yZ3QNCiAgICAgICAg QU5EIG5vZGUubGZ0IEJFVFdFRU4gc3ViX3BhcmVudC5sZnQgQU5EIHN1Yl9w YXJlbnQucmd0DQogICAgICAgIEFORCBzdWJfcGFyZW50Lm5hbWUgPSBzdWJf dHJlZS5uYW1lDQpHUk9VUCBCWSBub2RlLm5hbWUsIG5vZGUubGZ0LCBzdWJf dHJlZS5kZXB0aA0KT1JERVIgQlkgbm9kZS5sZnQ7DQorLS0tLS0tLS0tLS0t LS0tLS0tLS0tLSstLS0tLS0tLS0rDQp8IG5hbWUgICAgICAgICAgICAgICAg IHwgICBkZXB0aCB8DQp8LS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0t LS18DQp8IFBPUlRBQkxFIEVMRUNUUk9OSUNTIHwgICAgICAgMCB8DQp8IE1Q MyBQTEFZRVJTICAgICAgICAgIHwgICAgICAgMSB8DQp8IEZMQVNIICAgICAg ICAgICAgICAgIHwgICAgICAgMiB8DQp8IENEIFBMQVlFUlMgICAgICAgICAg IHwgICAgICAgMSB8DQp8IDIgV0FZIFJBRElPUyAgICAgICAgIHwgICAgICAg MSB8DQorLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0rDQoNCg0K U2VjdGlvbjogRmluZCB0aGUgSW1tZWRpYXRlIFN1Ym9yZGluYXRlcyBvZiBh IE5vZGUuDQpTRUxFQ1Qgbm9kZS5uYW1lLCAoQ09VTlQocGFyZW50Lm5hbWUp IC0gKHN1Yl90cmVlLmRlcHRoICsgMSkpIEFTIGRlcHRoDQpGUk9NIG5lc3Rl ZF9jYXRlZ29yeSBBUyBub2RlLA0KICAgICAgICBuZXN0ZWRfY2F0ZWdvcnkg QVMgcGFyZW50LA0KICAgICAgICBuZXN0ZWRfY2F0ZWdvcnkgQVMgc3ViX3Bh cmVudCwNCiAgICAgICAgKA0KICAgICAgICAgICAgICAgIFNFTEVDVCBub2Rl Lm5hbWUsIChDT1VOVChwYXJlbnQubmFtZSkgLSAxKSBBUyBkZXB0aA0KICAg ICAgICAgICAgICAgIEZST00gbmVzdGVkX2NhdGVnb3J5IEFTIG5vZGUsDQog ICAgICAgICAgICAgICAgbmVzdGVkX2NhdGVnb3J5IEFTIHBhcmVudA0KICAg ICAgICAgICAgICAgIFdIRVJFIG5vZGUubGZ0IEJFVFdFRU4gcGFyZW50Lmxm dCBBTkQgcGFyZW50LnJndA0KICAgICAgICAgICAgICAgIEFORCBub2RlLm5h bWUgPSAmIzM5O1BPUlRBQkxFIEVMRUNUUk9OSUNTJiMzOTsNCiAgICAgICAg ICAgICAgICBHUk9VUCBCWSBub2RlLm5hbWUsIG5vZGUubGZ0DQogICAgICAg ICAgICAgICAgT1JERVIgQlkgbm9kZS5sZnQNCiAgICAgICAgKUFTIHN1Yl90 cmVlDQpXSEVSRSBub2RlLmxmdCBCRVRXRUVOIHBhcmVudC5sZnQgQU5EIHBh cmVudC5yZ3QNCiAgICAgICAgQU5EIG5vZGUubGZ0IEJFVFdFRU4gc3ViX3Bh cmVudC5sZnQgQU5EIHN1Yl9wYXJlbnQucmd0DQogICAgICAgIEFORCBzdWJf cGFyZW50Lm5hbWUgPSBzdWJfdHJlZS5uYW1lDQpHUk9VUCBCWSBub2RlLm5h bWUsIG5vZGUubGZ0LCBzdWJfdHJlZS5kZXB0aA0KSEFWSU5HIGRlcHRoICZs dDs9IDENCk9SREVSIEJZIG5vZGUubGZ0Ow0KQWRkaW5nICYjMzk7SEFWSU5H IGRlcHRoICZsdDs9IDEmIzM5OyB0byB0aGUgcXVlcnkgc3RpbGwgcmV0dXJu IHRoZSBzYW1lIHJlc3VsdHMgYXMKYWJvdmUgaW5zdGVhZCBvZiB0aGlzOg0K Ky0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tKw0KfCBuYW1lICAg ICAgICAgICAgICAgICB8ICAgZGVwdGggfA0KfC0tLS0tLS0tLS0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tfA0KfCBQT1JUQUJMRSBFTEVDVFJPTklDUyB8ICAg ICAgIDAgfA0KfCBNUDMgUExBWUVSUyAgICAgICAgICB8ICAgICAgIDEgfA0K fCBGTEFTSCAgICAgICAgICAgICAgICB8ICAgICAgIDEgfA0KfCBDRCBQTEFZ RVJTICAgICAgICAgICB8ICAgICAgIDEgfA0KfCAyIFdBWSBSQURJT1MgICAg ICAgICB8ICAgICAgIDEgfA0KKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tKw0KDQoNCk5PVEU6IEkgZWRpdGVkIHRoZSBxdWVyeSBieSBhZGQg bm9kZS5sZnQsIHN1Yl90cmVlLmRlcHRoIHRvIHRoZSBHUk9VUCBCWS4NCg0K SSBkb24mIzM5O3Qga25vdyBpZiBJJiMzOTttIGRvaW5nIGFueXRoaW5nIHdy b25nPw0KCgotLSAKU2VudCB2aWEgcGdzcWwtZG9jcyBtYWlsaW5nIGxpc3Qg KHBnc3FsLWRvY3NAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0 byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y Zy9tYWlscHJlZi9wZ3NxbC1kb2NzCg==