Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1AFD76334DE for ; Tue, 20 Oct 2009 12:54:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65041-03-2 for ; Tue, 20 Oct 2009 15:54:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from jupiter.marktest.pt (delta.marktest.pt [80.251.174.116]) by mail.postgresql.org (Postfix) with ESMTP id 007C76331B5 for ; Tue, 20 Oct 2009 12:54:49 -0300 (ADT) Received: from Proteu (proteu.marktest.pt [10.61.90.54]) by jupiter.marktest.pt with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id 4R8TLBB2; Tue, 20 Oct 2009 16:54:48 +0100 Message-ID: From: "Oliveiros C," To: "Adrian Klaver" Cc: "Tom Lane" , References: <6caee9520910140240u13daba93ua20637642727776e@mail.gmail.com> <8017.1255973569@sss.pgh.pa.us> <754C7C57E773410197FA4BF910DE9973@marktestcr.marktest.pt> <200910200646.46157.aklaver@comcast.net> Subject: Re: How to order varchar data by word Date: Tue, 20 Oct 2009 16:54:47 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.184 tagged_above=-10 required=5 tests=BAYES_40=-0.185, STOX_REPLY_TYPE=0.001 X-Spam-Level: X-Archive-Number: 200910/77 X-Sequence-Number: 33276 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" To: "Oliveiros C," Cc: "Tom Lane" ; 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