Locale, LL_COLLATE and sorting case-insensatively

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Locale, LL_COLLATE and sorting case-insensatively
Date: 2010-06-09 12:53:34
Message-ID: 20100609085334.bff7f0c6.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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/

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-06-09 14:37:31 Re: server crash => libpq poll() hangs forever (Linux)
Previous Message Harald Fuchs 2010-06-09 12:32:21 Re: Some insight on the proper SQL would be appreciated