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
