agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed
From: Peter Eisentraut <peter_e@gmx.net>
To: Richard RK. Klingler <richard@klingler.net>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: IP address, subnet query behaves wrong for /32
Date: Mon, 17 Aug 2015 10:30:14 -0400
Message-ID: <55D1EFF6.8060703@gmx.net> (raw)
In-Reply-To: <10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

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



view thread (9+ messages)

Message-ID: <55D1EFF6.8060703@gmx.net>
Permalink:  ../55D1EFF6.8060703@gmx.net/
Also on:    postgresql.org/message-id/55D1EFF6.8060703@gmx.net

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: peter_e@gmx.net, richard@klingler.net
  Subject: Re: IP address, subnet query behaves wrong for /32
  In-Reply-To: <55D1EFF6.8060703@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox