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

From: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
To: "Richard RK(dot) Klingler" <richard(at)klingler(dot)net>
Cc: "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-06 19:45:32
Message-ID: 20150806194532.GL539@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Aug 06, 2015 at 07:35:19PM +0000, 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;
>
>
> cheers from .ch
> richard
>
What about:

select * from table order by inet(IP-ADDRESS);

Seems pretty straight-forward. What does MySQL do?

Regards,
Ken

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2015-08-06 19:53:33 Re: IP address, subnet query behaves wrong for /32
Previous Message Richard RK. Klingler 2015-08-06 19:35:19 Re: IP address, subnet query behaves wrong for /32