ORDER BY problem
От | Thomas Beutin |
---|---|
Тема | ORDER BY problem |
Дата | |
Msg-id | 20040301160135.A5856@laokoon.bug.net обсуждение исходный текст |
Ответы |
Re: ORDER BY problem
Re: ORDER BY problem |
Список | 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@laokoon.IN-Berlin.DE Beam me up, Scotty. There is no intelligent live down in Redmond.
В списке pgsql-general по дате отправления: