sorting on inet type?
От | Daniel J. Kressin |
---|---|
Тема | sorting on inet type? |
Дата | |
Msg-id | 3AB7907A.8D30911C@globalcrossing.com обсуждение исходный текст |
Ответы |
Re: sorting on inet type?
Re: sorting on inet type? |
Список | pgsql-general |
I have a table with an inet column, which I entered in order initially, so they came out like: 1.2.3.4 1.2.3.5 1.2.3.40 1.2.3.41 After updating, say, 1.2.3.5, it moves to the end. I understand why, that's not the problem. Adding an 'ORDER BY host(ip)' clause causes the ordering to be: 1.2.3.4 1.2.3.40 1.2.3.41 1.2.3.5 Is there an easy way to return to the original order, or do I need to write a custom PL/SQL function to parse the octets and do sorting manually? If the latter is the case, help/hints would be appreciated. Thanks. P.S. Thanks to the group for all the help you've given on my previous questions! -- Dan ____ Kressin ____ .-----------------------------------. /___ \____________/ __ \ | Unix SysAdmin | \ \ / / \ | | Global Crossing | ___/ __\/\/rench_ \__/ | | dkressin@globalcrossing.com | \____/ \____/ | http://www.vib.org/wrench/ | `-----------------------------------'
В списке pgsql-general по дате отправления: