Re: postgresql order lowercase before uppercase

[basti <mailinglist@xxxxxxxxxxxxxxxx>]

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