From: Lennin Caro <lennin.caro@yahoo.com>
To: pgsql-admin@postgresql.org, "Blanco, Jose" <blancoj@umich.edu>
Subject: Re: Ordering not acting right.
Date: Wed, 20 Aug 2008 13:25:49 -0700 (PDT)
Message-ID: <433178.17939.qm@web59506.mail.ac4.yahoo.com> (raw)
In-Reply-To: <E0217C87D1BA1043AC897ACFA468CEE6022EF9A8@ECLUST2-VS3.adsroot.itcs.umich.edu>
> 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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lennin.caro@yahoo.com, blancoj@umich.edu
Subject: Re: Ordering not acting right.
In-Reply-To: <433178.17939.qm@web59506.mail.ac4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox