Re: REGEXP_REPLACE woes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: CaT <cat(at)zip(dot)com(dot)au>
Cc: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: REGEXP_REPLACE woes
Date: 2008-06-10 14:54:03
Message-ID: 17467.1213109643@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CaT <cat(at)zip(dot)com(dot)au> writes:
> There's a bug in your version of pcre I think as postgres would have
> little to do with the regex itself (I be guessing).

You be wrong ... PG uses Tcl's regex engine, not pcre, and this behavior
is as documented. No, I don't know why Henry Spencer chose to do it
that way, but he's certainly forgotten more about REs than the rest of
us will ever know.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-06-10 14:57:37 Re: Multithreaded queue in PgSQL
Previous Message Richard Broersma 2008-06-10 14:24:13 Strange ODBC error & statement in Server log