Re: sorting on inet type?

I believe this is fixed in 7.1.

LER

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 3/20/01, 11:16:42 AM, Daniel "J." Kressin <dkressin(at)globalcrossing(dot)com>
wrote regarding [GENERAL] sorting on inet type?:

> 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(at)globalcrossing(dot)com |
> \____/ \____/ | http://www.vib.org/wrench/ |
> `-----------------------------------'

> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?

> http://www.postgresql.org/search.mpl