Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E647764FCD2 for ; Fri, 1 Aug 2008 05:31:04 -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 29784-05 for ; Fri, 1 Aug 2008 05:30:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from renaissance-it.com (unknown [164.164.87.55]) by postgresql.org (Postfix) with ESMTP id AEB1B650152 for ; Fri, 1 Aug 2008 05:30:56 -0300 (ADT) Received: (qmail 5288 invoked by uid 109); 1 Aug 2008 08:30:19 -0000 Received: from 192.168.1.6 by sritmail (envelope-from , uid 112) with qmail-scanner-1.25st (perlscan: 1.25st. Clear:RC:1(192.168.1.6):. Processed in 0.00953 secs); 01 Aug 2008 08:30:19 -0000 Received: from unknown (HELO praveenkm) (praveen.k@[192.168.1.6]) (envelope-sender ) by renaissance-it.com (qmail-ldap-1.03) with SMTP for ; 1 Aug 2008 08:30:19 -0000 Message-ID: <02cb01c8f3b1$83e51ad0$274610ac@praveenkm> From: "Praveen" To: Cc: Subject: Nls sorting in Postgresql-8.3.3 Date: Fri, 1 Aug 2008 14:05:12 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_02C8_01C8F3DF.9D8CB500" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.101 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200808/1 X-Sequence-Number: 29846 This is a multi-part message in MIME format. ------=_NextPart_000_02C8_01C8F3DF.9D8CB500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. Thanks in advance. Praveen Malik. ------=_NextPart_000_02C8_01C8F3DF.9D8CB500 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

I installed = postgresql-8.3.3 in our=20 local server with option --enable-nls . After successful installion , = I create=20 database and import data.But I = am not=20 aware how to use nls sort in = this postgresql-8.3.3 .

Please tell me syntax how to use nls = sort in=20 query , if some one = know.

Thanks in advance.

Praveen Malik.

------=_NextPart_000_02C8_01C8F3DF.9D8CB500--