Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 70303650030; Fri, 1 Aug 2008 05:43:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39117-10; Fri, 1 Aug 2008 05:43:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pih-relay08.plus.net (pih-relay08.plus.net [212.159.14.134]) by postgresql.org (Postfix) with ESMTP id 14CD9650020; Fri, 1 Aug 2008 05:43:54 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay08.plus.net with esmtp (Exim) id 1KOqEi-00044z-AX; Fri, 01 Aug 2008 09:43:44 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 23815274071; Fri, 1 Aug 2008 09:43:44 +0100 (BST) Message-ID: <4892CCC0.5030500@archonet.com> Date: Fri, 01 Aug 2008 09:43:44 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.16 (X11/20080707) MIME-Version: 1.0 To: Praveen CC: pgsql-admin@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] Nls sorting in Postgresql-8.3.3 References: <02cb01c8f3b1$83e51ad0$274610ac@praveenkm> In-Reply-To: <02cb01c8f3b1$83e51ad0$274610ac@praveenkm> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 15270be55b36c29d68692e6be5622752 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/2 X-Sequence-Number: 29847 Praveen wrote: > Hello, > I installed postgresql-8.3.3 in our local server with option --enable-nls . After successful installion , I create database and import data.But I am not aware how to use nls sort in this postgresql-8.3.3 . > Please tell me syntax how to use nls sort in query , if some one know. What is "nls sort"? What do you expect --enable-nls to do? It looks like it's for multi-language message display rather than sorting. The locale options are already built-in. -- Richard Huxton Archonet Ltd