title: postgresql tsvector partial text match
body: <p>I'm trying to create a PostgreSQL query to find a partial text inside a tsvector column. </p>
  
  <p>I have a tsvector value like this <code>"'89' 'TT7' 'test123'"</code> and I need to find any rows that contains "%es%".</p>
  
  <p>How can I do that?</p>
  
  <p>I tried </p>
  
  <pre><code>select * from use_docs_conteudo
  WHERE textodados @@ to_tsquery('es')
  </code></pre>