Re: How to order varchar data by word

Hello, Adrian, thanks for the links.

I enjoyed the technique on the end of the second page (on the version 8.3 
with comments), the shadow column trick.

Given that LC_COLLATE is immutable, unless a new database is created, I 
guess I'll give the shadow column a try.

Best,
Oliveiros

----- Original Message ----- 
From: "Adrian Klaver" <aklaver@comcast.net>
To: "Oliveiros C," <oliveiros.cristina@marktest.pt>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>; <pgsql-sql@postgresql.org>
Sent: Tuesday, October 20, 2009 2:46 PM
Subject: Re: [SQL] How to order varchar data by word


> On Tuesday 20 October 2009 6:39:23 am Oliveiros C, wrote:
>> Hello, Tom.
>>
>> Thank you for your e-mail
>>
>> Even though I am not familiar with the exact procedure to switch to other
>> locales,
>> I'm gonna research this more deeply.
>>
>> Anyway, I would appreciate if you could spare me some time and give me a
>> couple of pointers to this subject.
>>
>> Again, thank you
>>
>> Best,
>> Oliveiros
>>
>
> A good place to start is:
> http://www.postgresql.org/docs/8.4/interactive/locale.html
> Check out the Further Reading section at:
> http://www.postgresql.org/docs/8.4/interactive/multibyte.html#AEN30078
>
> -- 
> Adrian Klaver
> aklaver@comcast.net