I believe this is fixed in 7.1.
LER
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/20/01, 11:16:42 AM, Daniel "J." Kressin <dkressin@globalcrossing.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@globalcrossing.com |
> \____/ \____/ | http://www.vib.org/wrench/ |
> `-----------------------------------'
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> http://www.postgresql.org/search.mpl
