Problem in order by - Mailing list pgsql-admin

From Reuly Bússolo Mendes
Subject Problem in order by
Date
Msg-id 00b001c53e98$8c84c630$5c00a8c0@intranet.tecmicro.com.br
Whole thread Raw
Responses Re: Problem in order by
List 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 by date:

Previous
From: Thomas Kaminski
Date:
Subject: Re: pg_dump on remote machine
Next
From: Stephan Szabo
Date:
Subject: Re: Problem in order by