Re: Ordering not acting right.

Select name from info order by name;

-----Original Message-----
From: Lennin Caro [mailto:lennin(dot)caro(at)yahoo(dot)com]
Sent: Wednesday, August 20, 2008 4:26 PM
To: pgsql-admin(at)postgresql(dot)org; Blanco, Jose
Subject: Re: [ADMIN] Ordering not acting right.

> 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?