string comparison problem

From: "Johnny Edge" <edgewater(at)visafirst(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: string comparison problem
Date: 2011-08-01 18:12:48
Message-ID: 3CCE373A5F700D4AA37233BADC93F04C2218@bgva-s03-exch03.taxback.ess.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reuven M. Lerner 2011-08-01 18:25:50 Pending trigger events on ALTER TABLE in 8.3
Previous Message John Cheng 2011-08-01 17:50:03 Re: Postgres 8.0 upgrade to 9.0