title: How do you do phrase-based full text search in postgres that takes advantage of the full-text index?
body: <p>Let's say you have a postgres 8.3 table as follows:</p>
  
  <p><code>CREATE TABLE t1 (body text, body_vector tsvector);</code></p>
  
  <p>I want to be able to search it for phrases using the full text index (GiST, GiN or both on the tsvector column).  The best workaround I've been able to find is to first do the full text search on both words (boolean AND) and then do a like comparison on the body for the phrase.  Of course, this fails to capture any stemming or spell-checking that postgres' full-text search does for you.  An example of this is if I'm searching for the phrase 'w1 w2', I'd use:</p>
  
  <p><code>SELECT * FROM t1 WHERE body_vector @@ 'w1 &amp; w2'::tsquery AND body LIKE 'w1 w2';</code></p>
  
  <p>Is there a way to do this where you don't have to resort to searching on the text column?</p>