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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
