Thanks Josh
I normally use tsearch for full text search i will probably use that
or may be this what u suggested.
regds
mallah.
> Rajesh,
>
>> I want my query to use indexes for company name searches but its not happening
>unless
>> is use '=' which does not server the purpose.
>>
>> eg
>>
>
Rajesh,
> I want my query to use indexes for company name searches but its not
> happening unless
> is use '=' which does not server the purpose.
>
> eg
>
> tradein_clients=# explain SELECT co_name FROM unified_data where
> co_name ilike '%rajesh%' ;
Well, for an *anchored* case-insensitive
Hi folks,
can anyone tell me or point me to the right thread.
I want my query to use indexes for company name searches but its not happening unless
is use '=' which does not server the purpose.
eg
tradein_clients=# explain SELECT co_name FROM unified_data where co_name ilike
'%rajesh%' ;
N