Re: Order by and strings

From: Fredric Fredricson <Fredric(dot)Fredricson(at)bonetmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Order by and strings
Date: 2010-02-09 10:21:24
Message-ID: 4B713724.1060601@bonetmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Marlowe wrote:
> On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson
> <Fredric(dot)Fredricson(at)bonetmail(dot)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 Content-Type Size
Fredric.Fredricson.vcf text/x-vcard 207 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-02-09 10:38:40 Re: Memory Usage and OpenBSD
Previous Message Ivan Sergio Borgonovo 2010-02-09 10:18:42 border case ::tsvector vs. to_tsvector was turning a tsvector without position in a weighted tsvector