Re: postgresql order lowercase before uppercase

to me, collate 'C' ask for the raw ascii order which put caps before
because the hexa coding is lower
did you try any thing else (POSIX is same as 'C')

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Thu, Mar 18, 2021 at 4:18 PM basti <mailinglist(at)unix-solution(dot)de> wrote:

> 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(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
> >>
> >
>
>
>