Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D9842632D4C for ; Tue, 20 Oct 2009 10:46:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 65649-07 for ; Tue, 20 Oct 2009 13:46:40 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from QMTA06.emeryville.ca.mail.comcast.net (qmta06.emeryville.ca.mail.comcast.net [76.96.30.56]) by mail.postgresql.org (Postfix) with ESMTP id DF82E63281A for ; Tue, 20 Oct 2009 10:46:48 -0300 (ADT) Received: from OMTA16.emeryville.ca.mail.comcast.net ([76.96.30.72]) by QMTA06.emeryville.ca.mail.comcast.net with comcast id v0Tz1c0051ZMdJ4A61mocR; Tue, 20 Oct 2009 13:46:48 +0000 Received: from tucker.local ([24.17.164.54]) by OMTA16.emeryville.ca.mail.comcast.net with comcast id v1us1c0031Ak4z48c1uslK; Tue, 20 Oct 2009 13:54:53 +0000 From: Adrian Klaver To: "Oliveiros C," Subject: Re: How to order varchar data by word Date: Tue, 20 Oct 2009 06:46:45 -0700 User-Agent: KMail/1.9.10 Cc: "Tom Lane" , pgsql-sql@postgresql.org References: <6caee9520910140240u13daba93ua20637642727776e@mail.gmail.com> <8017.1255973569@sss.pgh.pa.us> <754C7C57E773410197FA4BF910DE9973@marktestcr.marktest.pt> In-Reply-To: <754C7C57E773410197FA4BF910DE9973@marktestcr.marktest.pt> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200910200646.46157.aklaver@comcast.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.37 tagged_above=-10 required=5 tests=AWL=0.229, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200910/76 X-Sequence-Number: 33275 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