Kristian Lance <kristian.lance@crc.ca> 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