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