Skip site navigation (1) Skip section navigation (2)

Re: Ordering not acting right.

From: "Blanco, Jose" <blancoj(at)umich(dot)edu>
To: <lennin(dot)caro(at)yahoo(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Ordering not acting right.
Date: 2008-08-20 20:27:32
Message-ID: E0217C87D1BA1043AC897ACFA468CEE6022EF9CE@ECLUST2-VS3.adsroot.itcs.umich.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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?




      


In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-08-20 20:31:37
Subject: Re: Ordering not acting right.
Previous:From: Lennin CaroDate: 2008-08-20 20:25:49
Subject: Re: Ordering not acting right.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group