string comparison problem - Mailing list pgsql-general

From Johnny Edge
Subject string comparison problem
Date
Msg-id 3CCE373A5F700D4AA37233BADC93F04C2218@bgva-s03-exch03.taxback.ess.ie
Whole thread Raw
Responses Re: string comparison problem  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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.
 
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.
 
 
 
 
 
On hostA :
 
visa2=# select count(1) from tblapplic where firstname>='george' and firstname<='georgezzzz';
 count
-------
   392
(1 row)
 
visa2=#  select count(1) from tblapplic where lower(firstname) like 'george%' ;
 count
-------
   392
(1 row)
 
 
On hostB :
 
 
 
visa2=# select count(1) from tblapplic where firstname>='george' and firstname<='georgezzzz';
 count
-------
     7
(1 row)
 
visa2=# select count(1) from tblapplic where lower(firstname) like 'george%' ;
 count
-------
   392
(1 row)
 
Thanks,
JE
 

pgsql-general by date:

Previous
From: "Johnny Edge"
Date:
Subject: string comparison problem
Next
From: John R Pierce
Date:
Subject: Re: string comparison problem