From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ORDER BY problem |
Date: | 2004-03-01 19:11:41 |
Message-ID: | 20040301191141.GA17382@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Mar 01, 2004 at 16:01:35 +0100,
Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)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(at)laokoon(dot)IN-Berlin(dot)DE
> Beam me up, Scotty. There is no intelligent live down in Redmond.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Shane Wegner | 2004-03-01 19:23:45 | Re: efficient storing of urls |
Previous Message | Bill Moran | 2004-03-01 18:09:35 | Re: value too long error |