title: Regex match on redshift
body: <p>I am having little trouble with regex on redshift. The regex works fine when i use it in my scala code but does not works on redshift. I understand that the syntax might be somewhat different in redshift. Can anyone help me out here.</p>
  
  <p>regex: <code>(^VISA\s*MONEY\s*TRANSFER\s*.*\s*CASH\s*APP\**\s*.*Visa Direct CA.*\s*)</code></p>
  
  <p>in redshift:</p>
  
  <pre><code>select *
  from table where column ~ '(^VISA\s*MONEY\s*TRANSFER\s*.*\s*CASH\s*APP\**\s*.*Visa Direct CA.*\s*)' limit 2;
  </code></pre>
  
  <p>Err:</p>
  
  <blockquote>
    <p>ERROR: XX000: Invalid preceding regular expression prior to repetition
    operator.  The error occurred while parsing the regular expression
    fragment: 'ASHs*APP**>>>HERE>>>s*.*Visa D'.</p>
  </blockquote>