Message-ID: <55D1EFF6.8060703@gmx.net>
Date: Mon, 17 Aug 2015 10:30:14 -0400
From: Peter Eisentraut <peter_e@gmx.net>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10;
 rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version: 1.0
To: "Richard RK. Klingler" <richard@klingler.net>,
 "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: IP address, subnet query behaves wrong for /32
References: <1FC8E571-8456-4085-B59B-016ECD365768@klingler.net>
 <55C39320.4010905@aklaver.com>
 <CAKFQuwaj9HFTAU-soNt3mn4rCTJ8FUgHtnTg+ZsV2oGmMT=n8w@mail.gmail.com>
 <16388.1438888231@sss.pgh.pa.us>
 <10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net>
In-Reply-To: <10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 8/6/15 3:35 PM, Richard RK. Klingler wrote:
> Thanks to all for the clarifications...
> 
> I'm looking at this form an application perspective...
> as this would greatly enhance an IPAM database web application.
> 
> Sad there is no direct IP address sorting function like in MySQL (o;

Many people prefer ip4r (https://github.com/RhodiumToad/ip4r) over the
built-in types.  You might find that they work better for you.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql