title: Regular expression in PostgreSQL LIKE clause
body: <p>I'm stuck with a simple regular expression. Not sure what I'm missing. A little rusty on regex skills.</p>
  
  <p>The expression I'm trying to match is:</p>
  
  <pre><code>select * from table where value like '00[1-9]%'
  -- (third character should not be 0)
  </code></pre>
  
  <p>So this should match <code>'0090D0DF143A'</code> (format: text) but it's NOT!</p>