Re: Regex Query Index question - Mailing list pgsql-general

Naoko Reeves <naokoreeves@gmail.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