Thread: Tsearch case sensitive with dotted search terms.

Tsearch case sensitive with dotted search terms.

From

Rajesh Kumar Mallah

Date:

07 June 2004, 07:57:26

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)

Re: Tsearch case sensitive with dotted search terms.

From

Teodor Sigaev

Date:

07 June 2004, 16:52:23

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: teodor@sigaev.ru

Attachment

tp.gz