Aaron Bingham <[EMAIL PROTECTED]> writes: > Here is a simple test case which triggers the problematic behavior. I > would expect the SQL regular expression and POSIX regular expression > below to give the same results. However, they produce different > answers. The difference seems to be caused by a naive implementation of > similar_escape(text, text) as also demonstrated below.
Yup, we fixed that in 8.1.4 ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend