| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Aaron Bingham <bingham(at)cenix-bioscience(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, Oliver Gathmann <gathmann(at)cenix-bioscience(dot)com>, Andrew Walsh <walsh(at)cenix-bioscience(dot)com>, Liisa Koski <koski(at)cenix-bioscience(dot)com> |
| Subject: | Re: SIMILAR TO incorrect with alternation |
| Date: | 2006-12-25 20:41:33 |
| Message-ID: | 25728.1167079293@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Aaron Bingham <bingham(at)cenix-bioscience(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-12-25 20:46:39 | Re: BUG #2861: when backup UTF-8 database, pgdump add comments not encoded in UTF-8 |
| Previous Message | Tom Lane | 2006-12-25 20:39:15 | Re: BUG #2862: ERROR: failed to build any 7-way joins |