string comparison problem

Поиск
Список
Период
Сортировка
От Johnny Edge
Тема string comparison problem
Дата
Msg-id 3CCE373A5F700D4AA37233BADC93F04C221A@bgva-s03-exch03.taxback.ess.ie
обсуждение исходный текст
Ответы Re: string comparison problem
Список 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
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Postgres 8.3 Function returning a row with different number of colums
Следующее
От: "Johnny Edge"
Дата:
Сообщение: string comparison problem