Re: ORDER BY problem

On Mon, Mar 01, 2004 at 16:01:35 +0100,
  Thomas Beutin <tyrone@laokoon.IN-Berlin.DE> wrote:
> Hi,
>
> when i do the following query i get an wrong result order on my postgres
> system (PostgreSQL 7.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2)
>
> tb_test=# SELECT name, upper(name) FROM tb_wurst ORDER BY upper(name);
>                name               |              upper
> ----------------------------------+----------------------------------
>  Americabound Tours, Inc.         | AMERICABOUND TOURS, INC.
>  American Airlines                | AMERICAN AIRLINES
>  American Express Tour Operador   | AMERICAN EXPRESS TOUR OPERADOR
>  American Receptive Tours         | AMERICAN RECEPTIVE TOURS
>  American Ring Travel, Inc.       | AMERICAN RING TRAVEL, INC.
>  American Sightseeing Chicago     | AMERICAN SIGHTSEEING CHICAGO
>  AMERICANTOURS INTERNATIONAL INC. | AMERICANTOURS INTERNATIONAL INC.
>  America West Airlines, Inc.      | AMERICA WEST AIRLINES, INC.
> (8 rows)
>
> The last line should IMHO be the first; but line 7 is in the correct place
> compared to lines 2-6.
> Has anybody any hint for me to resolve the problem?

This is a locale issue. You probably are using en_US for the cluster
instead of C. In 7.2 you need to do an initdb to change this.

>
> Any help is greatly appreciated.
> -tb
> --
> Thomas Beutin                             tb@laokoon.IN-Berlin.DE
> Beam me up, Scotty. There is no intelligent live down in Redmond.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster