Skip site navigation (1) Skip section navigation (2)

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: 2006-12-25 20:41:33
Message-ID: 25728.1167079293@sss.pgh.pa.us (view raw or flat)
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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-12-25 20:46:39
Subject: Re: BUG #2861: when backup UTF-8 database,pgdump add comments not encoded in UTF-8
Previous:From: Tom LaneDate: 2006-12-25 20:39:15
Subject: Re: BUG #2862: ERROR: failed to build any 7-way joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group