Re: SIMILAR TO incorrect with alternation - Mailing list pgsql-bugs

From Tom Lane
Subject Re: SIMILAR TO incorrect with alternation
Date
Msg-id 25728.1167079293@sss.pgh.pa.us
Whole thread Raw
In response to SIMILAR TO incorrect with alternation  (Aaron Bingham <bingham@cenix-bioscience.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2862: ERROR: failed to build any 7-way joins
Next
From: Tom Lane
Date:
Subject: Re: BUG #2861: when backup UTF-8 database,pgdump add comments not encoded in UTF-8