X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D18E03A587F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Dec 2004 19:28:53 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 70590-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Dec 2004 19:28:47 +0000 (GMT)
Received: from www.postgresql.com (unknown [200.46.204.209])
	by svr1.postgresql.org (Postfix) with ESMTP id 063B63A58DD
	for <pgsql-sql@postgresql.org>; Thu,  2 Dec 2004 19:28:19 +0000 (GMT)
Received: from bt2.jordan.pl (unknown [62.121.132.241])
	by www.postgresql.com (Postfix) with ESMTP id 6D07473A192
	for <pgsql-sql@postgresql.org>; Thu,  2 Dec 2004 07:17:59 +0000 (GMT)
Received: from localhost (localhost [127.0.0.1])
	by bt2.jordan.pl (Postfix) with ESMTP id C9CCF19C009;
	Thu,  2 Dec 2004 08:16:58 +0100 (CET)
Received: from bt2.jordan.pl ([127.0.0.1])
	by localhost (bt2 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
	id 04008-04; Thu, 2 Dec 2004 08:16:57 +0100 (CET)
Received: from [192.168.24.1] (chello083144087237.chello.pl [83.144.87.237])
	by bt2.jordan.pl (Postfix) with ESMTP id B70FE19C002;
	Thu,  2 Dec 2004 08:16:57 +0100 (CET)
Message-ID: <41AEC1AB.8030200@klaster.net>
Date: Thu, 02 Dec 2004 08:18:03 +0100
From: Tomasz Myrta <jasiek@klaster.net>
Organization: KLASTER
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: Simon Moses <ks_moses@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: order by problem
References: <20041201061449.42895.qmail@web14928.mail.yahoo.com>
In-Reply-To: <20041201061449.42895.qmail@web14928.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at bt2.jordan.pl
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.803 tagged_above=0 required=5 tests=DEAR_SOMETHING
X-Spam-Level: 
X-Archive-Number: 200412/23
X-Sequence-Number: 19643


>dear sir,
>when i run a query with order by customer_name i am
>getting the following result(ex.).
>
>AA
>A B
>AC
>
>i want it to be
>
>A B
>AA
>AB
>  
>
It's because of locales. Some special characteres are removed when 
sorting using locales. I'm not sure, but probably only "C" locale will 
give results you need.

Regards,
Tomasz Myrta