Cody Pisto <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] ~]$ cat fooey Somethang -SOMETHING ELSE- Something else [EMAIL PROTECTED] ~]$ LANG=C sort fooey -SOMETHING ELSE- Somethang Something else [EMAIL PROTECTED] ~]$ LANG=en_US sort fooey Somethang Something else -SOMETHING ELSE- [EMAIL PROTECTED] ~]$ 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