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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group