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
