title: Postgres Full Text Search on Array Column
body: <p>I have a <code>posts</code> that has a column <code>tags</code>. I'd like to be able to do full text search across the tags. For <code>VARCHAR</code> columns I've used:</p>
  
  <pre><code>CREATE INDEX posts_fts_idx ON posts USING gin(to_tsvector('english', coalesce(title, ''));
  SELECT "posts".* FROM "posts" WHERE (to_tsvector('english', coalesce(title, '')) @@ (to_tsquery('english', 'ruby')));
  </code></pre>
  
  <p>However, for <code>character varying[]</code> the function <code>to_tsvector</code> does not exist. How can a query be written that will run against each of the tags (ideally matching if any single tag matches)?</p>
  
  <p><strong>Note:</strong> I see that it would be pretty easy to do a conversion to a string (<code>array_to_string</code>) but if possible I'd like to convert each individual tag to a <code>tsvector</code>.</p>