DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=ij858nrYxtYzBhOT9QSwnwYkrUvtxKmplFGvDaYFmRFFH2OSH1t+KuvMhqIwFXtU+I
	U+tQAfch4KSjoVuQe6KnH9oC8r3qFu/HgaiMSRaXa+jlU6B9kMDcqbPVnfvhxhcDdYAI
	R5hn2g/uvhX29ntzgeqr2KeI3BTCUMjKQl0B8=
Message-ID: <dcc563d10808201331q4100490ay2b26d9a63cc84540@mail.gmail.com>
Date: Wed, 20 Aug 2008 14:31:37 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Blanco, Jose" <blancoj@umich.edu>
Subject: Re: Ordering not acting right.
Cc: pgsql-admin@postgresql.org
In-Reply-To: 
 <E0217C87D1BA1043AC897ACFA468CEE6022EF9A8@ECLUST2-VS3.adsroot.itcs.umich.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: 
 <E0217C87D1BA1043AC897ACFA468CEE6022EF9A8@ECLUST2-VS3.adsroot.itcs.umich.edu>

On Wed, Aug 20, 2008 at 1:48 PM, Blanco, Jose <blancoj@umich.edu> wrote:
> 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.

The best fix if you want ascii ordering is to re-initdb your db with
locale=C and then reload your data.

There's some stuff you can do with varchar_pattern_ops, but I'm not
sure it will work for order by in your situation.