postgresql tsvector partial text match
<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>