Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql order lowercase before uppercase - Mailing list pgsql-general

From Laurenz Albe
Subject Re: postgresql order lowercase before uppercase
Date
Msg-id fa00b39eb7c7589cd604e386ff9ce59997906f5d.camel@cybertec.at
Whole thread Raw
In response to postgresql order lowercase before uppercase  (basti <mailinglist@unix-solution.de>)
Responses Re: postgresql order lowercase before uppercase  (basti <mailinglist@unix-solution.de>)
List pgsql-general
Tree view 
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@CaseFirst=LowerFirst");

Then use

  ORDER BY name COLLATE inv

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

pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: Re: postgresql order lowercase before uppercase
Next
From: Peter Geoghegan
Date:
Subject: Re: Frequetly updated partial index leads to bloat on index for Postresql 11