More serious: apply attached patch, recompile and reinstall contrib/tsearch module. Patch commited to 7.3,7.4 and 7.5 branches, it fix asymetrical lexeme processing for text and query.
Rajesh Kumar Mallah wrote:
Hi,
I think when search terms have "."s in them they become case sensitive in tsearch searches. How can we make them insensitive?
Regds Mallah.
tradein_clients=# SELECT co_name , co_name_index from iid_listing where co_name_index ## 'a.u.m&logistics';
+------------------------------------+--------------------------------------+
| co_name | co_name_index |
+------------------------------------+--------------------------------------+
| A.U.M. LOGISTICS (I) PVT. LTD. | 'ltd' 'pvt' 'a.u.m' 'logist' |
| A.U.M. LOGISTICS (I) PVT. LTD. | 'ltd' 'pvt' 'a.u.m' 'logist' |
| A.U.M. LOGISTICS (INDIA) PVT. LTD. | 'ltd' 'pvt' 'a.u.m' 'india' 'logist' |
+------------------------------------+--------------------------------------+
(3 rows)
Time: 404.543 ms
tradein_clients=# SELECT co_name , co_name_index from iid_listing where co_name_index ## 'a.u.m&LOGISTICS';
+------------------------------------+--------------------------------------+
| co_name | co_name_index |
+------------------------------------+--------------------------------------+
| A.U.M. LOGISTICS (I) PVT. LTD. | 'ltd' 'pvt' 'a.u.m' 'logist' |
| A.U.M. LOGISTICS (I) PVT. LTD. | 'ltd' 'pvt' 'a.u.m' 'logist' |
| A.U.M. LOGISTICS (INDIA) PVT. LTD. | 'ltd' 'pvt' 'a.u.m' 'india' 'logist' |
+------------------------------------+--------------------------------------+
(3 rows)
Time: 425.697 ms
tradein_clients=# SELECT co_name , co_name_index from iid_listing where co_name_index ## 'A.U.M&LOGISTICS';
+---------+---------------+
| co_name | co_name_index |
+---------+---------------+
+---------+---------------+
(0 rows)
-- Teodor Sigaev E-mail: [EMAIL PROTECTED]
tp.gz
Description: Unix tar archive
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
