Re: postgresql order lowercase before uppercase

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: basti <mailinglist(at)unix-solution(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql order lowercase before uppercase
Date: 2021-03-18 16:19:56
Message-ID: fa00b39eb7c7589cd604e386ff9ce59997906f5d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2021-03-18 at 15:39 +0100, basti wrote:
> 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

Create an ICU collation:

CREATE COLLATION inv (PROVIDER = icu, LOCALE = "en-US(at)CaseFirst=LowerFirst");

Then use

ORDER BY name COLLATE inv

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2021-03-18 16:30:30 Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Previous Message Marc Millas 2021-03-18 15:46:16 Re: postgresql order lowercase before uppercase