Postgres Pro
Downloads
Home   >   mailing lists

postgresql order lowercase before uppercase - Mailing list pgsql-general

From basti
Subject postgresql order lowercase before uppercase
Date
Msg-id 5a174fad-c30d-6d65-38c8-a3d9af8377df@unix-solution.de
Whole thread Raw
Responses RE: postgresql order lowercase before uppercase
Re: postgresql order lowercase before uppercase
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Dearman
Date:
Subject: Frequetly updated partial index leads to bloat on index for Postresql 11
Next
From: "Basques, Bob (CI-StPaul)"
Date:
Subject: RE: postgresql order lowercase before uppercase