This message is a follow up to this thread:
http://archives.postgresql.org/pgsql-bugs/2001-12/msg8.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 s
The server is running:
PostgreSQL version 7.0.2
RedHat Linux 6.2
When using ORDER BY in an SQL statement where the data type is varchar and
the data are unix directory paths, the forward slashes (/) are ignored,
causing the results to be returned in the incorrect order.
Example:
Here is the
