Select name from info order by name; -----Original Message----- From: Lennin Caro [mailto:lennin.caro@xxxxxxxxx] Sent: Wednesday, August 20, 2008 4:26 PM To: pgsql-admin@xxxxxxxxxxxxxx; 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?
