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 >
