Re: string comparison problem

On Mon, Aug 1, 2011 at 2:47 PM, Johnny Edge <edgewater(at)visafirst(dot)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