Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZNOQd-0007qj-DC for pgsql-sql@arkaria.postgresql.org; Thu, 06 Aug 2015 16:54:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZNOQc-0001Xs-JZ for pgsql-sql@arkaria.postgresql.org; Thu, 06 Aug 2015 16:54:02 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZNOQb-0001Xg-Um for pgsql-sql@postgresql.org; Thu, 06 Aug 2015 16:54:02 +0000 Received: from mx.klingler.net ([213.193.121.99] helo=srv2012.klingler.net) by makus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZNOQZ-0003X6-63 for pgsql-sql@postgresql.org; Thu, 06 Aug 2015 16:54:00 +0000 Received: from SRV2012.klingler.net (10.0.1.1) by SRV2012.klingler.net (10.0.1.1) with Microsoft SMTP Server (TLS) id 15.0.847.32; Thu, 6 Aug 2015 18:47:50 +0200 Received: from SRV2012.klingler.net ([fe80::9d8f:eaf5:8d1c:f726]) by SRV2012.klingler.net ([fe80::9d8f:eaf5:8d1c:f726%12]) with mapi id 15.00.0847.030; Thu, 6 Aug 2015 18:47:50 +0200 From: "Richard RK. Klingler" To: "pgsql-sql@postgresql.org" Subject: IP address, subnet query behaves wrong for /32 Thread-Topic: IP address, subnet query behaves wrong for /32 Thread-Index: AQHQ0GehzrIwYMREfk6tTnO0eWxhHw== Date: Thu, 6 Aug 2015 16:47:49 +0000 Message-ID: <1FC8E571-8456-4085-B59B-016ECD365768@klingler.net> Accept-Language: de-CH, de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.0.60.4] Content-Type: multipart/alternative; boundary="_000_1FC8E57184564085B59B016ECD365768klinglernet_" MIME-Version: 1.0 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org --_000_1FC8E57184564085B59B016ECD365768klinglernet_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 RXZlbmluJw0KDQpXaGF0IEkgZGlzY292ZXJlZCBqdXN0IGxhdGVseSBpcyBhIG5pY2UgZmVhdHVy ZSBmcm9tIHBnc3FsIHRoYXQgSSBjYW4gdGVzdA0KaWYgYSBzcGVjaWZpYyBJUCBhZGRyZXNzIGZh bGxzIHdpdGhpbiBhIHN1cHBsaWVkIHN1Ym5ldDoNCg0KDQpteXNlcnZlcj0jIHNlbGVjdCBpbmV0 ICcxOTIuMTY4LjAuMScgPDwgJzE5Mi4xNjguMC4wLzI0Jzo6aW5ldCBhcyBpcDsNCg0KIGlwDQoN Ci0tLS0NCg0KIHQNCg0KKDEgcm93KQ0KDQoNCkJ1dCB3aGF0IEkgZG9uJ3QgdW5kZXJzdGFuZCBp cyB3aHkgcGdzcWwgZG9lc24ndCBiZWhhdmUgY29ycmVjdGx5IHdoZW4gdGVzdGluZyBmb3IgYSAv MzIgc3VibmV0Og0KKGl0IHdvcmtzIGZvciAvMzEgY29ycmVjdGx5IHRob3VnaCkNCg0KDQpteXNl cnZlcj0jIHNlbGVjdCBpbmV0ICcxOTIuMTY4LjAuMScgPDwgJzE5Mi4xNjguMC4xLzMyJzo6aW5l dCBhcyBpcDsNCg0KIGlwDQoNCi0tLS0NCg0KIGYNCg0KRnJvbSBhIG5ldHdvcmsgZW5naW5lZXJp bmcgcG9pbnQgb2YgdmlldyB0aGlzIHNob3VsZCBhbHNvIHJldHVybiAidHJ1ZSIgYW5kIG5vdCBm YWxzZS4NCg0KSGFzIHRoaXMgYmVlbiBmaXhlZCBpbiByZWNlbnQgdmVyc2lvbnM/IEknbSB1c2lu ZyA5LjIuOCByaWdodCBub3figKYuDQoNCg0KDQp0aGFua3MgaW4gYWR2YW5jZQ0KcmljaGFyZA0K DQoNCg== --_000_1FC8E57184564085B59B016ECD365768klinglernet_ Content-Type: text/html; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjwvaGVhZD4NCjxib2R5IHN0eWxlPSJ3b3JkLXdy YXA6IGJyZWFrLXdvcmQ7IC13ZWJraXQtbmJzcC1tb2RlOiBzcGFjZTsgLXdlYmtpdC1saW5lLWJy ZWFrOiBhZnRlci13aGl0ZS1zcGFjZTsgY29sb3I6IHJnYigwLCAwLCAwKTsgZm9udC1zaXplOiAx NHB4OyBmb250LWZhbWlseTogQ2FsaWJyaSwgc2Fucy1zZXJpZjsiPg0KPGRpdj5FdmVuaW4nPC9k aXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj5XaGF0IEkgZGlzY292ZXJlZCBqdXN0IGxhdGVs eSBpcyBhIG5pY2UgZmVhdHVyZSBmcm9tIHBnc3FsIHRoYXQgSSBjYW4gdGVzdDwvZGl2Pg0KPGRp dj5pZiBhIHNwZWNpZmljIElQIGFkZHJlc3MgZmFsbHMgd2l0aGluIGEgc3VwcGxpZWQgc3VibmV0 OjwvZGl2Pg0KPGRpdj48YnI+DQo8L2Rpdj4NCjxkaXY+DQo8cCBzdHlsZT0ibWFyZ2luOiAwcHg7 IGZvbnQtc2l6ZTogMTFweDsgZm9udC1mYW1pbHk6IE1lbmxvOyI+bXlzZXJ2ZXI9IyBzZWxlY3Qg aW5ldCAnMTkyLjE2OC4wLjEnICZsdDsmbHQ7ICcxOTIuMTY4LjAuMC8yNCc6OmluZXQgYXMgaXA7 PC9wPg0KPHAgc3R5bGU9Im1hcmdpbjogMHB4OyBmb250LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5 OiBNZW5sbzsiPiZuYnNwO2lwJm5ic3A7PC9wPg0KPHAgc3R5bGU9Im1hcmdpbjogMHB4OyBmb250 LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiPi0tLS08L3A+DQo8cCBzdHlsZT0ibWFy Z2luOiAwcHg7IGZvbnQtc2l6ZTogMTFweDsgZm9udC1mYW1pbHk6IE1lbmxvOyI+Jm5ic3A7dDwv cD4NCjxwIHN0eWxlPSJtYXJnaW46IDBweDsgZm9udC1zaXplOiAxMXB4OyBmb250LWZhbWlseTog TWVubG87Ij4oMSByb3cpPC9wPg0KPC9kaXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj48YnI+ DQo8L2Rpdj4NCjxkaXY+QnV0IHdoYXQgSSBkb24ndCB1bmRlcnN0YW5kIGlzIHdoeSBwZ3NxbCBk b2Vzbid0IGJlaGF2ZSBjb3JyZWN0bHkgd2hlbiB0ZXN0aW5nIGZvciBhIC8zMiBzdWJuZXQ6PC9k aXY+DQo8ZGl2PihpdCB3b3JrcyBmb3IgLzMxIGNvcnJlY3RseSB0aG91Z2gpPC9kaXY+DQo8ZGl2 Pjxicj4NCjwvZGl2Pg0KPGRpdj4NCjxwIHN0eWxlPSJtYXJnaW46IDBweDsgZm9udC1zaXplOiAx MXB4OyBmb250LWZhbWlseTogTWVubG87Ij5teXNlcnZlcj0jIHNlbGVjdCBpbmV0ICcxOTIuMTY4 LjAuMScgJmx0OyZsdDsgJzE5Mi4xNjguMC4xLzMyJzo6aW5ldCBhcyBpcDs8L3A+DQo8cCBzdHls ZT0ibWFyZ2luOiAwcHg7IGZvbnQtc2l6ZTogMTFweDsgZm9udC1mYW1pbHk6IE1lbmxvOyI+Jm5i c3A7aXAmbmJzcDs8L3A+DQo8cCBzdHlsZT0ibWFyZ2luOiAwcHg7IGZvbnQtc2l6ZTogMTFweDsg Zm9udC1mYW1pbHk6IE1lbmxvOyI+LS0tLTwvcD4NCjxwIHN0eWxlPSJtYXJnaW46IDBweDsgZm9u dC1zaXplOiAxMXB4OyBmb250LWZhbWlseTogTWVubG87Ij4mbmJzcDtmPC9wPg0KPC9kaXY+DQo8 ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj5Gcm9tIGEgbmV0d29yayBlbmdpbmVlcmluZyBwb2ludCBv ZiB2aWV3IHRoaXMgc2hvdWxkIGFsc28gcmV0dXJuICZxdW90O3RydWUmcXVvdDsgYW5kIG5vdCBm YWxzZS48L2Rpdj4NCjxkaXY+PGJyPg0KPC9kaXY+DQo8ZGl2PkhhcyB0aGlzIGJlZW4gZml4ZWQg aW4gcmVjZW50IHZlcnNpb25zPyBJJ20gdXNpbmcgOS4yLjggcmlnaHQgbm934oCmLjwvZGl2Pg0K PGRpdj48YnI+DQo8L2Rpdj4NCjxkaXY+PGJyPg0KPC9kaXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0K PGRpdj50aGFua3MgaW4gYWR2YW5jZTwvZGl2Pg0KPGRpdj5yaWNoYXJkPC9kaXY+DQo8ZGl2Pjxi cj4NCjwvZGl2Pg0KPGRpdj48YnI+DQo8L2Rpdj4NCjxkaXY+DQo8ZGl2IGlkPSJNQUNfT1VUTE9P S19TSUdOQVRVUkUiPjwvZGl2Pg0KPC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo= --_000_1FC8E57184564085B59B016ECD365768klinglernet_--