Aaron Bingham <bingham@cenix-bioscience.com> 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