Re: problem with ORDER BY - Mailing list pgsql-general

From Nicolas KOWALSKI
Subject Re: problem with ORDER BY
Date
Msg-id 87y7a56kbi.fsf@petole.dyndns.org
Whole thread Raw
In response to Re: problem with ORDER BY  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: problem with ORDER BY
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:

> On Fri, Feb 01, 2008 at 11:06:07AM +0100, Nicolas KOWALSKI wrote:
>>
>> I do not understand why the following ORDER BY statment does not work
>> as I would expect:
>>
>> 3) When I want to sort them, I get this "strange" ordering:
>
> Show us your collation order:
> show lc_collate;

Here it is:

mon=> show lc_collate;
 lc_collate
-------------
 en_US.UTF-8
(1 row)

Thanks,
--
Nicolas

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: problem with ORDER BY
Next
From: Enrico Sirola
Date:
Subject: arrays of floating point numbers / linear algebra operations into the DB