Re: regexp_replace - Mailing list pgsql-patches

From Tom Lane
Subject Re: regexp_replace
Date
Msg-id 1774.1118072367@sss.pgh.pa.us
Whole thread Raw
In response to Re: regexp_replace  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: regexp_replace  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> Don't we have this functionality already?  It's even SQL-spec ...

> Uh, all I see it replace(), which isn't regex:

The SQL-spec function is substring(string from pattern for escape-char);
see
http://www.postgresql.org/docs/8.0/static/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP

and we also have a variant of that for POSIX rather than SQL-style
regexps:
http://www.postgresql.org/docs/8.0/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: regexp_replace
Next
From: Bruce Momjian
Date:
Subject: Re: regexp_replace