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" <akla...@comcast.net>
To: "Oliveiros C," <oliveiros.crist...@marktest.pt>
Cc: "Tom Lane" <t...@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
akla...@comcast.net
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
