Re: Regex bug

David Fetter <david@fetter.org> writes:
> Here's a symptom as reported by John Hansen aka applejack:

> SELECT 'r'||'\000\125'||'hello' ~ '^.hello' AS "OMG";

This is not a regex bug: it has to do with the fact that we don't
support embedded nulls in text values.  This may enlighten you
a bit as to what's happening:

regression=# select length ('\000\125');
 length
--------
      0
(1 row)


            regards, tom lane