Re: Order by and strings

[Fredric Fredricson <Fredric.Fredricson@xxxxxxxxxxxxx>]

Scott Marlowe wrote:

On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson
<Fredric.Fredricson@xxxxxxxxxxxxx> 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

begin:vcard
fn:Fredric Fredricson
n:Fredricson;Fredric
org:Ln4 Solutions AB
email;internet:Fredric.Fredricson@xxxxxxxxxxxxx
title:CTO
tel;home:+46 8 91 64 39
tel;cell:+46 70 677 58 48
version:2.1
end:vcard

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general