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(at)comcast(dot)net>
To: "Oliveiros C," <oliveiros(dot)cristina(at)marktest(dot)pt>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>; <pgsql-sql(at)postgresql(dot)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(at)comcast(dot)net