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" <[email protected]>
To: "Oliveiros C," <[email protected]>
Cc: "Tom Lane" <[email protected]>; <[email protected]>
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
[email protected]
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
