title: Full text search on substring in PostgreSQL
body: <p>I am trying to retrieve the data from the a database using <code>to_tsquery()</code> on the basis of text search. I am able to get the results for complete word search but not for the substring. </p>
  
  <p>Example:</p>
  
  <pre><code>SELECT * FROM snp_gene_context
  WHERE protein_name @@ to_tsquery('english','KIN') AND gene_dist='0';
  </code></pre>
  
  <p>I am able to get the rows containing the word 'KIN11' but I am unable to get rows containing 'Kinase'.</p>