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