"Daniel J. Kressin" <[EMAIL PROTECTED]> writes:
> 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

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"?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to