Postgres Pro
Downloads
Home   >   mailing lists

Thread: string comparison problem

string comparison problem

From
"Johnny Edge"
Date:
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
 

Re: string comparison problem

From
Merlin Moncure
Date:
On Mon, Aug 1, 2011 at 2:47 PM, Johnny Edge <edgewater@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