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

Поиск
Список
Период
Сортировка
От ktm@rice.edu
Тема Re: IP address, subnet query behaves wrong for /32
Дата
Msg-id 20150806194532.GL539@aart.rice.edu
обсуждение исходный текст
Ответ на Re: IP address, subnet query behaves wrong for /32  ("Richard RK. Klingler" <richard@klingler.net>)
Список 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 по дате отправления:

Предыдущее
От: "Richard RK. Klingler"
Дата:
Сообщение: Re: IP address, subnet query behaves wrong for /32
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: IP address, subnet query behaves wrong for /32