"Daniel J. Kressin" <dkressin@globalcrossing.com> writes:
> Tom Lane wrote:
>> host(ip) produces a text result, so the above sort is according to
>> string-comparison rules. If you want a numeric sort why don't
>> you just "ORDER BY ip"?
> "ORDER BY ip" didn't work. I'm assuming this is the broken behaviour
> that Larry mentioned is fixed in 7.1.
Ah. Sorry, I tried it in current sources to verify that it produced
the sort order you wanted ... but I forgot that we'd done some work
on inet since 7.0.*.
regards, tom lane