X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 16A6153777 for ; Mon, 11 Apr 2005 10:13:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11832-10 for ; Mon, 11 Apr 2005 13:13:47 +0000 (GMT) Received: from itapoa.terra.com.br (itapoa.terra.com.br [200.154.55.227]) by svr1.postgresql.org (Postfix) with ESMTP id A61AE53754 for ; Mon, 11 Apr 2005 10:13:46 -0300 (ADT) Received: from paramonga.terra.com.br (paramonga.terra.com.br [200.154.55.133]) by itapoa.terra.com.br (Postfix) with ESMTP id ECA9730CF52 for ; Mon, 11 Apr 2005 10:13:49 -0300 (BRT) X-Terra-Karma: -2% X-Terra-Hash: 5f2efe143ca3a35f79c9f1d1bbcbce96 Received-SPF: pass (paramonga.terra.com.br: domain of terra.com.br designates 200.154.55.133 as permitted sender) client-ip=200.154.55.133; envelope-from=reuly@terra.com.br; helo=reuly; Received: from reuly (200-138-202-089.bnut37001.e.brasiltelecom.net.br [200.138.202.89]) (authenticated user reuly) by paramonga.terra.com.br (Postfix) with ESMTP id B33E421C01D for ; Mon, 11 Apr 2005 10:13:49 -0300 (BRT) Message-ID: <00b001c53e98$8c84c630$5c00a8c0@intranet.tecmicro.com.br> From: =?iso-8859-1?Q?Reuly_B=FAssolo_Mendes?= To: Subject: Problem in order by Date: Mon, 11 Apr 2005 10:15:35 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.678 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, UPPERCASE_50_75 X-Spam-Level: ** X-Archive-Number: 200504/138 X-Sequence-Number: 17151 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