Kristian Lance <[EMAIL PROTECTED]> writes: > This message is a follow up to this thread: > http://archives.postgresql.org/pgsql-bugs/2001-12/msg00008.php
> I finally got a chance to rebuild the DB server using C locale, and it made > no difference to my ORDER BY problem. PostgreSQL did not distinguish > between slashes, dashes, and spaces when sorting the records. I don't believe you did it right then :-(. That sure sounds like a locale-driven behavior. Try examining the pg_control file with contrib/pg_controldata to confirm for certain what the collation is. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])