From: | "Ozer, Pam" <pozer(at)automotive(dot)com> |
---|---|
To: | "Ozer, Pam" <pozer(at)automotive(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Samuel Gendler" <sgendler(at)ideasculptor(dot)com>, <emilu(at)encs(dot)concordia(dot)ca>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Sorting Issue |
Date: | 2011-05-25 22:18:20 |
Message-ID: | 216FFB77CBFAEE4B8EE4DF0A939FF1D14F8659@mail-001.corp.automotive.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Since no one has responded does that mean there is no list anywhere? Or
does anyone know of a collation that will allow for case insensitive
sorting as well as not ignoring spaces?
-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Ozer, Pam
Sent: Wednesday, May 18, 2011 3:22 PM
To: Tom Lane
Cc: Samuel Gendler; emilu(at)encs(dot)concordia(dot)ca; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Sorting Issue
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:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, May 10, 2011 9:47 AM
To: Ozer, Pam
Cc: Samuel Gendler; emilu(at)encs(dot)concordia(dot)ca; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Sorting Issue
"Ozer, Pam" <pozer(at)automotive(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Koczan | 2011-05-25 22:23:26 | Re: enum data type vs table |
Previous Message | Andrej | 2011-05-25 22:15:50 | Re: extracting location info from string |