Problem in order by

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

Responses

Browse pgsql-admin by date

  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