From praveen.k@renaissance-it.com Fri Aug  1 08:31:04 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id E647764FCD2
	for <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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
	<praveen.k@renaissance-it.com>, 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 <praveen.k@renaissance-it.com>)
	by renaissance-it.com (qmail-ldap-1.03) with SMTP
	for <pgsql-admin@postgresql.org>; 1 Aug 2008 08:30:19 -0000
Message-ID: <02cb01c8f3b1$83e51ad0$274610ac@praveenkm>
From: "Praveen" <praveen.k@renaissance-it.com>
To: <pgsql-admin@postgresql.org>
Cc: <pgsql-performance@postgresql.org>
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT size=3D3>I installed =
postgresql-8.3.3 in our=20
local server&nbsp; with option</FONT> &nbsp;<FONT face=3D"Courier New"=20
size=3D3><FONT face=3DArial>--enable-nls . After successful installion , =
I create=20
database and import data.</FONT></FONT></FONT><FONT face=3DArial>But I =
am not=20
aware how to use nls sort in =
this&nbsp;postgresql-8.3.3&nbsp;.</FONT></DIV>
<DIV><FONT face=3DArial>Please tell me &nbsp;syntax how&nbsp;to use nls =
sort in=20
query&nbsp;,</FONT><FONT face=3DArial>&nbsp;if some one =
know.</FONT></DIV>
<DIV><FONT face=3DArial>Thanks in advance.</FONT></DIV>
<DIV><FONT face=3DArial>Praveen Malik.</FONT></DIV></BODY></HTML>

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





From dev@archonet.com Fri Aug  1 08:43:57 2008
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 <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.16 (X11/20080707)
MIME-Version: 1.0
To: Praveen <praveen.k@renaissance-it.com>
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



From mathias@globalinn.com Sat Aug  2 11:39:28 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 40FD8650054
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat,  2 Aug 2008 08:39:28 -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 82190-03 for <pgsql-admin-postgresql.org@postgresql.org>;
	Sat,  2 Aug 2008 08:39:20 -0300 (ADT)
X-Greylist: delayed 01:00:00.324386 by SQLgrey-1.7.6
Received: from globalinn.com (mail.globalinn.se [80.75.24.2])
	by postgresql.org (Postfix) with ESMTP id 81388650048
	for <pgsql-admin@postgresql.org>; Sat,  2 Aug 2008 08:39:24 -0300 (ADT)
X-Antivirus-Scanned: McAfee
Received: from [217.210.59.25] (account mathias HELO [10.0.1.200])
	by globalinn.com (CommuniGate Pro SMTP 5.0.11)
	with ESMTPSA id 32594603 for pgsql-admin@postgresql.org;
	Sat, 02 Aug 2008 12:39:20 +0200
Message-Id: <080FA0CC-6B2E-4B5E-985C-79C5FF624638@globalinn.com>
From: =?ISO-8859-1?Q?Mathias_Stjernstr=F6m?= <mathias@globalinn.com>
To: pgsql-admin@postgresql.org
In-Reply-To: <02cb01c8f3b1$83e51ad0$274610ac@praveenkm>
Content-Type: multipart/signed; protocol="application/pgp-signature";
	micalg=pgp-sha1; boundary="Apple-Mail-2-995675236"
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v928.1)
Subject: Re: Nls sorting in Postgresql-8.3.3
X-Priority: 3
Date: Sat, 2 Aug 2008 12:39:19 +0200
References: <02cb01c8f3b1$83e51ad0$274610ac@praveenkm>
X-Pgp-Agent: GPGMail d53 (v53, Leopard)
X-Mailer: Apple Mail (2.928.1)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200808/7
X-Sequence-Number: 29852

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--Apple-Mail-2-995675236
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit

Hi!

NLS stands for "Native Language Support" and it's used for display  
error/information messages in different languages.

For sorting data you need to look at LC_COLLATE (http://www.postgresql.org/docs/8.3/interactive/locale.html 
)

You also need to check that you operation system support collation for  
your charset/encoding as PostgreSQL relies on the underling operation- 
systems collation support. FreeBSD for example does not support UTF-8  
collation. On FreeBSD you need the supplied ICU (http://www.icu-project.org/ 
) patch supplied by portage to get working UTF-8 collation.

Best regards,
Mathias Stjernstrom

--------------------------------------
http://www.globalinn.com/


On 1 aug 2008, at 10.35, 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.
> Thanks in advance.
> Praveen Malik.


--Apple-Mail-2-995675236
content-type: application/pgp-signature; x-mac-type=70674453;
	name=PGP.sig
content-description: This is a digitally signed message part
content-disposition: inline; filename=PGP.sig
content-transfer-encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)

iQEcBAEBAgAGBQJIlDlYAAoJEMkN6DtuoU6XxUgH/3+qX+0OXSVL15Sz0MZD6Yrg
XIJ0aMkqlZuvevVmOIN876ANO5OdhZsq3IEu7vJjqqnpUC7kDPuPyID3B3cGvy7Y
xSkxgjXG4Qh/oBhu4cwydM3ymD9DYuu63v8EyhR3flbO4fpMBAsq3VHmlS62MLOO
mePrn3aLT/A8WGwWnY5rMHZjCGIkn8+8f4zjvzWRuL2HuDBhOJ54ox1E0DZ/JXRc
BbX95z/DZQw4iO+KEpVwqnQIjgqcEX5aRskBYZYO2zwcOOz3MCiAU5uVvFGwtEP6
M90D0ZOt302RzLjcs6LCKGIKNh4j9YqidIOfCTSVZuEdiFQA/j8SdDgIyMOYN10=
=zXLq
-----END PGP SIGNATURE-----

--Apple-Mail-2-995675236--