Use tsearch2, tsearch is marked as obsolet :)
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:
te****@sigaev.ru
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org