From: | Reuly Bússolo Mendes <reuly(at)terra(dot)com(dot)br> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Problem in order by |
Date: | 2005-04-11 13:15:35 |
Message-ID: | 00b001c53e98$8c84c630$5c00a8c0@intranet.tecmicro.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2005-04-11 15:05:58 | Re: Problem in order by |
Previous Message | Thomas Kaminski | 2005-04-11 10:17:39 | Re: pg_dump on remote machine |