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
Martijn van Oosterhout
Date:
On Mon, Aug 01, 2011 at 10:53:16PM +0300, Johnny Edge 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.

It's probably locale related. Postgres uses the same order as the
"sort" command.

Try "show lc_collate".

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
   -- Arthur Schopenhauer

Attachment

Re: string comparison problem

From
kleptog@svana.org
Date:
This message has been digitally signed by the sender.
Attachment