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')
On Thu, Mar 18, 2021 at 4:18 PM basti <mailinglist@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx>
>> Sent: Thursday, March 18, 2021 9:40 AM
>> To: pgsql-general@xxxxxxxxxxxxxx
>> 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
>>
>
