prasanna@semantifi.com wrote:
> select sckw.*
> FROM semantified_content_key_word sckw
> where TO_TSVECTOR(sckw.key_word_text) @@ TO_TSQUERY('exhausted');
>
> This is the query which i am running.And the keyword "exhausted" is present
> only in one of the rows but i am getting all the 3 rows.
My guess, without actual experimentation, is that "exhausted" stems down
to "exhaust", which is present in the three provided rows.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services