Re: Order by and strings - Mailing list pgsql-general

From Fredric Fredricson
Subject Re: Order by and strings
Date
Msg-id 4B713724.1060601@bonetmail.com
Whole thread Raw
In response to Re: Order by and strings  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Order by and strings
List pgsql-general
Scott Marlowe wrote:
On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson
<Fredric.Fredricson@bonetmail.com> wrote: 
I use locale en_US.UTF-8 but why this should affect how leading characters
in strings are ignored is beyond me.   
P.s. this page may shed some light on the subject:

http://en.wikipedia.org/wiki/Collation
OK, thanks. It did shed some light on the subject. Only I wonder what would happen if these sort algorithms where used on things like article numbers in the industry. That would confuse the hell out of the people there.
Alas, not my problem. I have a work around that works for my little part of the universe. At least for now.

You live, you learn.
/Fredric
Attachment

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: logging statements from hibernate to valid SQL
Next
From: Scott Marlowe
Date:
Subject: Re: Memory Usage and OpenBSD