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 7C8A8537D1 for ; Mon, 11 Apr 2005 12:06:07 -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 56550-01 for ; Mon, 11 Apr 2005 15:06:03 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id D4E2853792 for ; Mon, 11 Apr 2005 12:06:02 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id CF1C835648; Mon, 11 Apr 2005 08:05:58 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id CAD063562A; Mon, 11 Apr 2005 08:05:58 -0700 (PDT) Date: Mon, 11 Apr 2005 08:05:58 -0700 (PDT) From: Stephan Szabo To: =?iso-8859-1?Q?Reuly_B=FAssolo_Mendes?= Cc: pgsql-admin@postgresql.org Subject: Re: Problem in order by In-Reply-To: <00b001c53e98$8c84c630$5c00a8c0@intranet.tecmicro.com.br> Message-ID: <20050411080350.I28912@megazone.bigpanda.com> References: <00b001c53e98$8c84c630$5c00a8c0@intranet.tecmicro.com.br> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=iso-8859-1 Content-Transfer-Encoding: QUOTED-PRINTABLE X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.468 tagged_above=0 required=5 tests=AWL, UPPERCASE_50_75 X-Spam-Level: X-Archive-Number: 200504/139 X-Sequence-Number: 17152 On Mon, 11 Apr 2005, [iso-8859-1] Reuly B=FAssolo Mendes wrote: > 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? This probably is because you have a different collation set on the redhat box. If you are using something other than "C" locale, the ordering on the redhat box seems reasonable given that most locales ignore spaces for their first pass, so 'TELHAO' < 'TELHA P' for example. If you want byte ordering sorting, you can initdb in "C" locale.