Postgres Pro
Downloads
Home   >   mailing lists

Locale, LL_COLLATE and sorting case-insensatively - Mailing list pgsql-general

From Bill Moran
Subject Locale, LL_COLLATE and sorting case-insensatively
Date
Msg-id 20100609085334.bff7f0c6.wmoran@potentialtech.com
Whole thread Raw
List pgsql-general
Tree view 
Is there a way to sort case-insensitively without using LOWER()?

I thought that a combination of encoding and LC_COLLATE would achieve
this, but everything I've tried so far has resulted in the dreaded
caps-come-first(tm) behavior.

A setting in the DB to force text fields to be sorted case insensitively
would do a lot to simplify parts of our application.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

pgsql-general by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: Some insight on the proper SQL would be appreciated
Next
From: Tom Lane
Date:
Subject: Re: server crash => libpq poll() hangs forever (Linux)