Ordering not acting right.

From: "Blanco, Jose" <blancoj(at)umich(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Ordering not acting right.
Date: 2008-08-20 19:48:17
Message-ID: E0217C87D1BA1043AC897ACFA468CEE6022EF9A8@ECLUST2-VS3.adsroot.itcs.umich.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Thank you!
Jose

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lennin Caro 2008-08-20 20:25:49 Re: Ordering not acting right.
Previous Message Kevin Grittner 2008-08-20 13:10:59 Re: Regarding access to a user