Redshift / Regular Expression (Negative Lookahead) does not work
<p>When I use negative lookahead (something like <code>(?!abc)</code>) on redshift,
redshift returns the error like this:</p>

<pre><code>-- Find records that do not start with abc
select * from table_a where column_a ~ '^(?!abc).+$'
</code></pre>

<blockquote>
  <p>Error: PG::InternalError: ERROR: Invalid preceding regular expression prior to repetition operator. The error occured while parsing the regular expression: '^(?>>>HERE>>>!abc).+$'. DETAIL: ----------------------------------------------- error: Invalid preceding regular expression prior to repetition operator. The error occured while parsing the regular expression: '^(?>>>HERE>>>!abc).+$'. code: 8002 context: T_regexp_init query: 1039510 location: funcs_expr.cpp:130</p>
</blockquote>

<p>It looks like Redshift does not recognize negative lookahead...<br>
Is there any way I can use it on Redshift?</p>