| From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Tsearch case sensitive with dotted search terms. |
| Date: | 2004-06-07 07:58:22 |
| Message-ID: | 40C4201E.2030006@trade-india.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Együd Csaba | 2004-06-07 08:38:27 | pg_dump, bytea, dump order questions |
| Previous Message | Michal Hlavac | 2004-06-07 07:42:02 | pg_dump and tsearch2 |