Re: lc_collate issue

Cody Pisto <cpisto(at)rvweb(dot)com> writes:
> If this is potentially a problem in postgres somewhere, point me in the
> general direction and I'm more than willing to fix it myself..

You seem not to have absorbed what I said. This *is* the correct result
according to that locale's definition of sorting. You can demonstrate
that without any use of Postgres:

[tgl(at)rh2 ~]$ cat fooey
Somethang
-SOMETHING ELSE-
Something else
[tgl(at)rh2 ~]$ LANG=C sort fooey
-SOMETHING ELSE-
Somethang
Something else
[tgl(at)rh2 ~]$ LANG=en_US sort fooey
Somethang
Something else
-SOMETHING ELSE-
[tgl(at)rh2 ~]$

If you prefer C sort ordering, run Postgres in C locale. It's as
simple as that.

regards, tom lane