Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Problem with PostgreSQL string sorting Hello All, - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Problem with PostgreSQL string sorting Hello All,
Date
Msg-id CAKFQuwayzxP=QSFP4vMnTe_cKEtQrxzYwHbR6zpspP=sUV2OdQ@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Problem with PostgreSQL string sorting Hello All,  (Hari Sankar A <hsshanthamhari@gmail.com>)
List pgsql-general
Tree view
On Wed, Feb 15, 2017 at 9:01 AM, Hari Sankar A <hsshanthamhari@gmail.com> wrote:
​[...]​

I can use lower() and collate 'C' to get this result. But I need a default collate to support this.

Is there any collation that support both (Case insensitive and special character) sorting in utf8?


your help would be really appreciated.


​Duplicate post on -bugs already answered - it came through the mail system first even through this is the correct list for the topic.

David J.
​

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Next
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries