Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 0A4EA64FCE6
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 20 Aug 2008 17:27:30 -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 40186-05-6 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 20 Aug 2008 17:27:22 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from n3a.bullet.mail.ac4.yahoo.com (n3a.bullet.mail.ac4.yahoo.com
	[76.13.13.66]) by postgresql.org (Postfix) with SMTP id 198006501E1
	for <pgsql-admin@postgresql.org>; Wed, 20 Aug 2008 17:25:50 -0300 (ADT)
Received: from [76.13.13.25] by n3.bullet.mail.ac4.yahoo.com with NNFMP;
	20 Aug 2008 20:25:49 -0000
Received: from [76.13.10.173] by t4.bullet.mail.ac4.yahoo.com with NNFMP;
	20 Aug 2008 20:25:49 -0000
Received: from [127.0.0.1] by omp114.mail.ac4.yahoo.com with NNFMP;
	20 Aug 2008 20:25:49 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 661481.39661.bm@omp114.mail.ac4.yahoo.com
Received: (qmail 18982 invoked by uid 60001); 20 Aug 2008 20:25:49 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID;
	b=ADXrZnOQDhc9/Qy0wd+zBKub9yam78q3X6oZkom3TqBNB2AtpCpbHpc1oD2dMG/upGmgMMRKyIqhZcIAD18dA76a3pPZi4KclaABCkkGoRbzC8/SmC6cEVepoq51+uxc1hkUJYo8xD8bXCPm3Vi8nQafa3UsWyYqCqJ7Yzi2rjg=;
X-YMail-OSG: 
 C34NTvMVM1lcxQ1aqYAmXpE8ypFdC1yZh1X50Y3xK491G80.MUFJ6jQvWs0MX9OVfCkGi7DZfO.coYRTc8H9Hkvb0qwncGW3LisI7rIIWw--
Received: from [209.88.228.11] by web59506.mail.ac4.yahoo.com via HTTP;
	Wed, 20 Aug 2008 13:25:49 PDT
X-Mailer: YahooMailWebService/0.7.218.2
Date: Wed, 20 Aug 2008 13:25:49 -0700 (PDT)
From: Lennin Caro <lennin.caro@yahoo.com>
Reply-To: lennin.caro@yahoo.com
Subject: Re: Ordering not acting right.
To: pgsql-admin@postgresql.org, "Blanco, Jose" <blancoj@umich.edu>
In-Reply-To: 
 <E0217C87D1BA1043AC897ACFA468CEE6022EF9A8@ECLUST2-VS3.adsroot.itcs.umich.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Message-ID: <433178.17939.qm@web59506.mail.ac4.yahoo.com>
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/89
X-Sequence-Number: 29934

> I have a text field which I use to store names ( lastname,
> firstname )
> and suppose we have the following 3 authors in the field:
>    ta, a
>    ta, z
>    tab, a
> 
> I would expect them to show up in the order shown above
> when I select
> this field and order it by it, but instead I get:
> 
>    ta, a
>    tab, a
>    ta, z
> 
> Some one has suggested that this may have to do with my
> locale setting.
> I'm not an administrator so I'm not sure what how
> to check for the
> locale setting or what to change it to.  Does any one have
> any
> suggestions?
> 
> I'm using postgres 8.1.11.

can you show the query sintax?