From: Oliveiros C, <oliveiros.cristina@marktest.pt>
To: Adrian Klaver <aklaver@comcast.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to order varchar data by word
Date: Tue, 20 Oct 2009 16:54:47 +0100
Message-ID: <F3A1F3A4DD63473D939C4FE4C611044C@marktestcr.marktest.pt> (raw)
References: <6caee9520910140240u13daba93ua20637642727776e@mail.gmail.com>
<8017.1255973569@sss.pgh.pa.us>
<754C7C57E773410197FA4BF910DE9973@marktestcr.marktest.pt>
<200910200646.46157.aklaver@comcast.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oliveiros.cristina@marktest.pt, aklaver@comcast.net, tgl@sss.pgh.pa.us
Subject: Re: How to order varchar data by word
In-Reply-To: <F3A1F3A4DD63473D939C4FE4C611044C@marktestcr.marktest.pt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox