Maybe check out using the UPPER/LOWER/INITCAP functions in the order by clause?
Bobb
> -----Original Message-----
> From: basti <mailinglist(at)unix-solution(dot)de>
> Sent: Thursday, March 18, 2021 9:40 AM
> To: pgsql-general(at)postgresql(dot)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
>