From: | Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ORDER BY problem |
Date: | 2004-03-01 15:01:35 |
Message-ID: | 20040301160135.A5856@laokoon.bug.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2004-03-01 15:28:37 | Re: ORDER BY problem |
Previous Message | Bill Moran | 2004-03-01 13:56:46 | Re: INSERTS and Queries |