string comparison problem

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