On Thu, 29 Nov 2001, Kristian Lance wrote:
> 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
Kristian Lance <[EMAIL PROTECTED]> writes:
> Note that the program appears to make no distinction between /x/c and
> /xc.
Sounds like you're running in en_US locale. You might prefer to use
plain C locale.
regards, tom lane
---(end of broadcast)
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
