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