| 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: | Whole Thread | Raw Message | 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 |