Re: IP address, subnet query behaves wrong for /32

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Richard RK(dot) Klingler" <richard(at)klingler(dot)net>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: IP address, subnet query behaves wrong for /32
Date: 2015-08-17 14:30:14
Message-ID: 55D1EFF6.8060703@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2015-08-23 21:01:01 WHERE ... NOT NULL ... OR ... (SELECT...)
Previous Message Stuart 2015-08-17 14:13:46 Re: ERROR: cache lookup failed for type