postgres full text search and spring-data hibernate
<p>I have a table with the following columns:</p>

<p>id,
url,
content</p>

<p>So there are lots of records with url, content where to search, etc</p>

<p>I need to write a query in postgres 9.5 which takes my custom search string like</p>

<p>'I want to search bla bla' and search for all possible entries in 'content' column, and then return ids of records where it found matches. May I use for it sth like </p>

<pre><code>SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat &amp; rat');
</code></pre>

<p>or is there any more advanced tool for this? Also, how to gracefuly integrate it with spring-data? Thanks</p>