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  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Kaminski
Дата:
Сообщение: Re: pg_dump on remote machine
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Problem in order by