Postgres Pro
Downloads
Home   >   mailing lists

Tsearch case sensitive with dotted search terms. - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject Tsearch case sensitive with dotted search terms.
Date
Msg-id 40C4201E.2030006@trade-india.com
Whole thread Raw
Responses Re: Tsearch case sensitive with dotted search terms.  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-general
Tree view

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)

pgsql-general by date:

Previous
From: Michal Hlavac
Date:
Subject: pg_dump and tsearch2
Next
From: Együd Csaba
Date:
Subject: pg_dump, bytea, dump order questions