Subject: Re: [GENERAL] string comparison problem
From: Martijn van Oosterhout <[email-masked]>
To: Johnny Edge <[email-masked]>
Cc: [email-masked]
Date: Mon, 1 Aug 2011 22:53:16 +0200
List-Id: <pgsql-general.postgresql.org>

On Mon, Aug 01, 2011 at 10:53:16PM +0300, Johnny Edge wrote:
> Hi folks,
>  
> I have a problem with identical versions of postgresql - 8.3.13 
>  
> Config files are identical. HostA is a 32 bit CentOS 5.3 install and the
> hostB is x86_64 CentOS 6.
>  
> Difference in architecture should not be a problem - I have another 64
> bit CentOS where both queries are executed displaying identical results.

It's probably locale related. Postgres uses the same order as the
"sort" command.

Try "show lc_collate".

Hope this helps,
-- 
Martijn van Oosterhout   <[email-masked]>   http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
   -- Arthur Schopenhauer