Is there anywhere that gives you all the available collations and their definitions? I found with the C collation it now sorts the spaces correct but it is also case sensitive which messes with some of our other sorts.
-----Original Message----- From: Tom Lane [mailto:[email protected]] Sent: Tuesday, May 10, 2011 9:47 AM To: Ozer, Pam Cc: Samuel Gendler; [email protected]; [email protected] Subject: Re: [SQL] Sorting Issue "Ozer, Pam" <[email protected]> writes: > Isn't this the English standard for collation? Or is this a non-c > locale as mentioned below? Is there anyway around this? > LC_COLLATE = 'en_US.utf8' en_US is probably using somebody's idea of "dictionary order", which I believe includes ignoring spaces in the first pass. You might be happier using "C" collation. Unfortunately that requires re-initdb'ing your database (as of existing PG releases). regards, tom lane -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
