Re: IP address, subnet query behaves wrong for /32 - Mailing list pgsql-sql

From ktm@rice.edu
Subject Re: IP address, subnet query behaves wrong for /32
Date
Msg-id 20150806194532.GL539@aart.rice.edu
Whole thread Raw
In response to Re: IP address, subnet query behaves wrong for /32  ("Richard RK. Klingler" <richard@klingler.net>)
List 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



pgsql-sql by date:

Previous
From: "Richard RK. Klingler"
Date:
Subject: Re: IP address, subnet query behaves wrong for /32
Next
From: Adrian Klaver
Date:
Subject: Re: IP address, subnet query behaves wrong for /32