On Mon, Aug 1, 2011 at 2:47 PM, Johnny Edge <edgewa...@visafirst.com> wrote: > 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
are you sure those servers are configured the same? check string encoding and locale settings. Look for any/all settings from pg_settings that might be different... merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
