Postgres Pro
Downloads
Home   >   mailing lists

string comparison problem - Mailing list pgsql-general

From Johnny Edge
Subject string comparison problem
Date
Msg-id 3CCE373A5F700D4AA37233BADC93F04C221B@bgva-s03-exch03.taxback.ess.ie
Whole thread Raw
Responses Re: string comparison problem
List pgsql-general
Tree view
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: Merlin Moncure
Date:
Subject: Re: string comparison problem
Next
From: "Reuven M. Lerner"
Date:
Subject: Re: Pending trigger events on ALTER TABLE in 8.3