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.  (Teodor Sigaev <teodor@sigaev.ru>)
Список 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 по дате отправления:

Предыдущее
От: Michal Hlavac
Дата:
Сообщение: pg_dump and tsearch2
Следующее
От: Együd Csaba
Дата:
Сообщение: pg_dump, bytea, dump order questions