Re: Regex Query Index question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Naoko Reeves <naokoreeves(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Regex Query Index question
Date: 2011-08-11 23:54:37
Message-ID: 13745.1313106877@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Naoko Reeves <naokoreeves(at)gmail(dot)com> writes:
> Also forgot to mentioned the version:
> select version() >> "PostgreSQL 8.4.6 on i386-apple-darwin, compiled by GCC
> i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5370),

Oh --- there's your problem. In 8.4 and earlier, we don't trust \( to be
a literal character in a regex pattern, because it's not a literal if
you have regex_flavor set to 'basic'. 9.0 and up removed that option,
so it works as-expected in newer versions.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-08-11 23:58:08 Re: Regex Query Index question
Previous Message David Johnston 2011-08-11 23:50:19 Re: COPY from .csv File and Remove Duplicates