title: ERROR: operator does not exist: numeric ~* unknown
body: <p>I need to created <code>domain</code> in PostgreSQL for a price. The price must be <code>NUMERIC(9,2)</code> where 9 is precision and 2 - scale. When trying to create domain getting:</p>
  
  <p><code>ERROR: operator does not exist: numeric ~* unknown</code>
  <code>Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.</code></p>
  
  <p><strong>QUERY:</strong></p>
  
  <pre><code>CREATE DOMAIN d_price AS NUMERIC(9, 2) NOT NULL 
  CONSTRAINT Product_price_can_contain_only_double_precision_value
  CHECK(VALUE ~*'^(([[:digit:]])+\.([[:digit:]]){2})$');
  </code></pre>