title: How can I use tsvector on a string with numbers?
body: <p>I would like to use a postgres tsquery on a column that has strings that all contain numbers, like this:</p>
  
  <pre><code>FRUIT-239476234
  </code></pre>
  
  <p>If I try to make a tsquery out of this:</p>
  
  <pre><code>select to_tsquery('FRUIT-239476234');
  </code></pre>
  
  <p>What I get is:</p>
  
  <pre><code>'fruit' &amp; '-239476234'
  </code></pre>
  
  <p>I want to be able to search by just the numeric portion of this value like so:</p>
  
  <pre><code>239476234
  </code></pre>
  
  <p>It seems that it is unable to match this because it is interpreting my hyphen as a "negative sign" and doesn't think <code>239476234</code> matches <code>-239476234</code>.  How can I tell postgres to treat <em>all</em> of my characters as text and not try to be smart about numbers and hyphens?</p>