On 08/07/2014 12:10 PM, Adrian Klaver wrote:
On 08/07/2014 08:53 AM, Steve Clark wrote:
On 08/07/2014 11:36 AM, Kevin Grittner wrote:
Steve Clark <sclark@xxxxxxxxxxxxx> wrote:
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Hi Kevin,
Thanks for the response. I get the same thing as postgres if I sort from
the command line too. But I don't understand why.
Because that is how en_US.UTF-8 sorts. You are probably looking for the
'C' sort order. For more explanations see:
http://rhaas.blogspot.com/2012/03/perils-of-collation-aware-comparisons.html
http://superuser.com/questions/227925/in-utf-8-collation-why-11-is-less-then-1
I would expect '-F' to sort immediately after '-' and '--' not after 'F' as
well as ' Feneric' (spaceFeneric) and ' Generic' (spaceGeneric) to sort
immediately after ' ' (space).
It is like the space character and the - in -Letter is ignored.
See the second link above for why that is.
Thanks Adrian and Kevin,
for the explanations and links. They were very elucidating. At least now I understand what is happening.
Thanks again.
--
Stephen Clark
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
