> *Modified Query :-
>
> *SELECT count(*) from page_content
> WHERE publishing_date like '%2010%' and content_language='en' and
> content is not null and isprocessable = 1 and
> to_tsvectOR('english',content) @@ to_tsquery('english','Mujahid' ||
> 'jihad' || 'Militant' || 'fedayeen' || 'insurgent' || 'terrORist' ||
> 'cadre' || 'civilians' || 'police' || 'defence' || 'cops' || 'crpf' ||
> 'dsf' || 'ssb');
I guess there should be spaces between the words. This way it's just one
very long word 'MujahidjihadMilitantfedayeen....' and I doubt that's what
you're looking for.
regards
Tomas
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
