Re: postgresql order lowercase before uppercase

Exactly.  "C" collation is the opposite of what he wants.

OP needs something like "de_DE".

On 3/18/21 10:36 AM, Marc Millas wrote:

to me, collate 'C' ask for the raw ascii order which put caps before because the hexa coding is lower

did you try any thing else (POSIX is same as 'C')

Marc MILLAS

Senior Architect

+33607850334

www.mokadb.com

On Thu, Mar 18, 2021 at 4:18 PM basti <mailinglist@unix-solution.de> wrote:

This does not help in that case.

On 18.03.21 15:45, Basques, Bob (CI-StPaul) wrote:
> Maybe check out using  the UPPER/LOWER/INITCAP functions in the order by clause?
>
> Bobb
>
>
>
>> -----Original Message-----
>> From: basti <mailinglist@unix-solution.de>
>> Sent: Thursday, March 18, 2021 9:40 AM
>> To: pgsql-general@postgresql.org
>> Subject: postgresql order lowercase before uppercase
>>
>> Think Before You Click: This email originated outside our organization.
>>
>>
>> Hello,
>> I need to as follow:
>>
>> ande
>> Amma
>> Anit
>> Anti
>> Brac
>> Cali
>> ....
>>
>> I have try ORDER by name COLLATE 'C';
>>
>> but this order as follow:
>>
>> Amma
>> Anit
>> Anti
>> Brac
>> Cali
>> ....
>> ande
>>
>> Best Regards
>>
>

--
Angular momentum makes the world go 'round.