Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZNR2S-0007TW-Es for pgsql-sql@arkaria.postgresql.org; Thu, 06 Aug 2015 19:41:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZNR2R-0003GE-6v for pgsql-sql@arkaria.postgresql.org; Thu, 06 Aug 2015 19:41:15 +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) (envelope-from ) id 1ZNR2P-0003Ei-HU for pgsql-sql@postgresql.org; Thu, 06 Aug 2015 19:41:13 +0000 Received: from mx.klingler.net ([213.193.121.99] helo=srv2012.klingler.net) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZNR2L-0006Oe-J7 for pgsql-sql@postgresql.org; Thu, 06 Aug 2015 19:41:12 +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 21:35:20 +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 21:35:20 +0200 From: "Richard RK. Klingler" To: "pgsql-sql@postgresql.org" Subject: Re: IP address, subnet query behaves wrong for /32 Thread-Topic: [SQL] IP address, subnet query behaves wrong for /32 Thread-Index: AQHQ0GehzrIwYMREfk6tTnO0eWxhH53/EP4AgAABeoCAACJRgIAAKemA Date: Thu, 6 Aug 2015 19:35:19 +0000 Message-ID: <10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net> References: <1FC8E571-8456-4085-B59B-016ECD365768@klingler.net> <55C39320.4010905@aklaver.com> <16388.1438888231@sss.pgh.pa.us> In-Reply-To: <16388.1438888231@sss.pgh.pa.us> 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: text/plain; charset="utf-8" Content-ID: <85CDD58856ECDE439391F0899AAD2222@klingler.net> Content-Transfer-Encoding: base64 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 VGhhbmtzIHRvIGFsbCBmb3IgdGhlIGNsYXJpZmljYXRpb25zLi4uDQoNCkkn bSBsb29raW5nIGF0IHRoaXMgZm9ybSBhbiBhcHBsaWNhdGlvbiBwZXJzcGVj dGl2ZS4uLg0KYXMgdGhpcyB3b3VsZCBncmVhdGx5IGVuaGFuY2UgYW4gSVBB TSBkYXRhYmFzZSB3ZWIgYXBwbGljYXRpb24uDQoNClNhZCB0aGVyZSBpcyBu byBkaXJlY3QgSVAgYWRkcmVzcyBzb3J0aW5nIGZ1bmN0aW9uIGxpa2UgaW4g TXlTUUwgKG87DQoNCg0KY2hlZXJzIGZyb20gLmNoDQpyaWNoYXJkDQoNCg0K DQoNCkFtIFtEQVRFXSBzY2hyaWViICJwZ3NxbC1zcWwtb3duZXJAcG9zdGdy ZXNxbC5vcmcgaW0gQXVmdHJhZyB2b24gVG9tIExhbmUiIDxbQUREUkVTU10+ Og0KDQo+IkRhdmlkIEcuIEpvaG5zdG9uIiA8ZGF2aWQuZy5qb2huc3RvbkBn bWFpbC5jb20+IHdyaXRlczoNCj4+IE9uIFRodSwgQXVnIDYsIDIwMTUgYXQg MTA6MDIgQU0sIEFkcmlhbiBLbGF2ZXIgPGFkcmlhbi5rbGF2ZXJAYWtsYXZl ci5jb20+DQo+PiB3cm90ZToNCj4+PiAiIElmIHRoZSBuZXRtYXNrIGlzIDMy IGFuZCB0aGUgYWRkcmVzcyBpcyBJUHY0LCB0aGVuIHRoZSB2YWx1ZSBkb2Vz IG5vdA0KPj4+IGluZGljYXRlIGEgc3VibmV0LCBvbmx5IGEgc2luZ2xlIGhv c3QuIg0KPj4+IA0KPj4+IFNvIGl0IGlzIGJlaGF2aW5nIGFzIGRvY3VtZW50 ZWQuDQo+DQo+PiBUaGlzIHNlZW1zIG92ZXJseSBzaW1wbGlmaWVkIGdpdmVu IHRoYXQgIjw8PSIgd2lsbCBpbmRlZWQgbWF0Y2ggdHdvIGhvc3QNCj4+IHNw ZWNpZmljYXRpb25zLg0KPg0KPk5vLCBvbmx5IG9uZS4gIFRoZXJlIGlzIG5v IGRpZmZlcmVuY2UgYmV0d2VlbiAnMTkyLjE2OC4wLjEnOjppbmV0IGFuZA0K PicxOTIuMTY4LjAuMS8zMic6OmluZXQ7IHRoZXkncmUgdGhlIHNhbWUgdmFs dWUuICBUaGUgZmlyc3Qgbm90YXRpb24NCj5pcyBtZXJlbHkgYSBzaG9ydGhh bmQgZm9yIHRoZSBzZWNvbmQuDQo+DQo+CQkJcmVnYXJkcywgdG9tIGxhbmUN Cj4NCj4NCj4tLSANCj5TZW50IHZpYSBwZ3NxbC1zcWwgbWFpbGluZyBsaXN0 IChwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcpDQo+VG8gbWFrZSBjaGFuZ2Vz IHRvIHlvdXIgc3Vic2NyaXB0aW9uOg0KPmh0dHA6Ly93d3cucG9zdGdyZXNx bC5vcmcvbWFpbHByZWYvcGdzcWwtc3FsDQoKLS0gClNlbnQgdmlhIHBnc3Fs LXNxbCBtYWlsaW5nIGxpc3QgKHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZykK VG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8v d3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXNxbAo=