Maybe check out using the UPPER/LOWER/INITCAP functions in the order by clause?
Bobb > -----Original Message----- > From: basti <[email protected]> > Sent: Thursday, March 18, 2021 9:40 AM > To: [email protected] > 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 >
