title: Efficient way to convert regular expression date for PostgreSQL
body: <p>I'm wondering if there is a way to convert any regular expression on date field in a proper date in PostreSQL.</p>
  
  <p>I want to convert this "WHERE" statement into a proper timestamp comparison: </p>
  
  <pre><code>WHERE date::text ~ '2013-0[1-9]-(0[1-9]|1[0-5])'
  </code></pre>
  
  <p>The fact is this is really slow. I guess because pgsql timestamp was not made for text regular expression search.</p>
  
  <p>However, writing regular expression in a html field is much more easy for me to develop than using a lot a javascripts widgets. The regular expression is much more flexible also.</p>
  
  <p>I take any solutions or advices</p>
  
  <p>Thanks,</p>