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 <mailingl...@unix-solution.de>
Sent: Thursday, March 18, 2021 9:40 AM
To: pgsql-gene...@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
