Acc.到 Amazon Redshift文档，可以与〜运算符配合使用的正则表达式符合POSIX标准.这意味着没有环视支持，并且您不能使用(?！...)，也不能使用(?<！...)构造成这些模式.

Acc. to the Amazon Redshift documentation, the regular expressions you can use with ~ operator comply with the POSIX standard. That means there is no lookaround support and you cannot use (?!...), nor (?<!...) constructs in these patterns.

如果字符串不是以模式开头，则似乎要匹配它.在这种情况下，您可以使用取反的正则表达式运算符版本！〜.

It seems that you want to match a string if it does not start with a pattern. In this case, you may use the negated regex operator version, !~.

where column_a !~ '^abc'