David Fetter <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster