Re: string comparison problem

Many thanks guys !!

Everyone who suggested cause of problem due to LC_COLLATE setting C was
correct.

Problem is resolved.

Apologies for the multiple post.

Kind regards,
JE

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John R Pierce
Sent: Monday, August 01, 2011 10:58 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] string comparison problem

On 08/01/11 11:12 AM, Johnny Edge wrote:
> 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.
> However, libraries which postgresql is compiled against on host B are
> significantly newer.
> Any thoughts how can this be resolved?
> PostgreSQL is compiled from source on both servers.

same client encoding on both instances?

SHOW CLIENT_ENCODING;
SHOW LC_COLLATE;

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To
make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general