Problem in order by
От | Reuly Bússolo Mendes |
---|---|
Тема | Problem in order by |
Дата | |
Msg-id | 00b001c53e98$8c84c630$5c00a8c0@intranet.tecmicro.com.br обсуждение исходный текст |
Ответы |
Re: Problem in order by
|
Список | pgsql-admin |
Hi, I make a dump from a database in cygwin in Windows to PG 7.3 in linux Red Hat 9. But I have a problem with 'order by'. The query is 'select prodes from es002 where prodes like 'TELHA%' order by 1' In the Cygwin, the return is correct: prodes ---------------------------------------------------- TELHA FRANCESA CAMBORIU TELHA PORTUGUESA SAO CRISTOVAO TELHA ROMANA LEONEL PEREIRA TELHA TRANSPARENTE FRANCESA TELHA TRANSPARENTE PORTUGUESA TELHA TRANSPARENTE ROMANA TELHA ZINCO 1 1/2 P/POSTE TELHADO TELHAO FRANCES SAO CRISTOVAO * TELHAO ROMANO SAO CRISTOVAO-GOIVA * But in Linux the return is: prodes ---------------------------------------------------- TELHA FRANCESA CAMBORIU TELHAO FRANCES SAO CRISTOVAO * TELHAO ROMANO SAO CRISTOVAO-GOIVA * TELHA PORTUGUESA SAO CRISTOVAO TELHA ROMANA LEONEL PEREIRA TELHA TRANSPARENTE FRANCESA TELHA TRANSPARENTE PORTUGUESA TELHA TRANSPARENTE ROMANA TELHA ZINCO 1 1/2 P/POSTE TELHADO I already executed vacuumbd and reindex database but nothing. Somebody could help me? Tks Reuly Mendes
В списке pgsql-admin по дате отправления: