Re: SQL Query Problem - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: SQL Query Problem
Date
Msg-id 20011203102702.O93342-100000@megazone23.bigpanda.com
Whole thread Raw
In response to SQL Query Problem  (Kristian Lance <kristian.lance@crc.ca>)
List pgsql-bugs
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 returned in the incorrect order.

Are you running with locale enabled and what are the LC_* settings you
are starting the server with?

pgsql-bugs by date:

Previous
From: "Mike Smialek"
Date:
Subject: case sensititvity bug in foreign keys on cygwin
Next
From: Tom Lane
Date:
Subject: Re: SQL Query Problem