| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Daniel J(dot) Kressin" <dkressin(at)globalcrossing(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: sorting on inet type? |
| Date: | 2001-03-20 18:07:28 |
| Message-ID: | 11694.985111648@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Daniel J. Kressin" <dkressin(at)globalcrossing(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-03-20 18:32:49 | Re: Re: [GENERAL] Re: temp table creation |
| Previous Message | Peter Eisentraut | 2001-03-20 18:02:22 | Re: Re: [GENERAL] Re: temp table creation |