Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: SIMILAR TO incorrect with alternation
- 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: Mon, 25 Dec 2006 15:41:33 -0500
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
- References:
- SIMILAR TO incorrect with alternation
- From: Aaron Bingham
- SIMILAR TO incorrect with alternation
- Prev by Date: Re: BUG #2862: ERROR: failed to build any 7-way joins
- Next by Date: Re: BUG #2861: when backup UTF-8 database,pgdump add comments not encoded in UTF-8
- Previous by thread: SIMILAR TO incorrect with alternation
- Next by thread: bug: Mac OS X 10.4.8 Intel
- Indexes: