Tsearch case sensitive with dotted search terms.
| От | Rajesh Kumar Mallah |
|---|---|
| Тема | Tsearch case sensitive with dotted search terms. |
| Дата | |
| Msg-id | 40C4201E.2030006@trade-india.com обсуждение исходный текст |
| Ответы |
Re: Tsearch case sensitive with dotted search terms.
|
| Список | pgsql-general |
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 по дате отправления: