Re: SQL Query Problem

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Kristian Lance <kristian(dot)lance(at)crc(dot)ca>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: SQL Query Problem
Date: 2001-12-03 18:28:00
Message-ID: 20011203102702.O93342-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-12-03 18:28:35 Re: SQL Query Problem
Previous Message Beerman, Michael B 2001-12-03 17:54:49 Re: Bug #525: createlang for plperl fails on Tru64 version 4.0F (v 7.1.3)