Cody Pisto <cpisto@xxxxxxxxx> 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@rh2 ~]$ cat fooey Somethang -SOMETHING ELSE- Something else [tgl@rh2 ~]$ LANG=C sort fooey -SOMETHING ELSE- Somethang Something else [tgl@rh2 ~]$ LANG=en_US sort fooey Somethang Something else -SOMETHING ELSE- [tgl@rh2 ~]$ If you prefer C sort ordering, run Postgres in C locale. It's as simple as that. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
