regexp_replace - Mailing list pgsql-sql

From Marcin Krawczyk
Subject regexp_replace
Date
Msg-id 95f6bf9b0808010422q4a16b3balc19790de5328e267@mail.gmail.com
Whole thread Raw
Responses Re: regexp_replace
List pgsql-sql
Hi all. I'd like to know whether it's possible to reverse the
behaviour of regexp_replace, meaning :
now if I do
SELECT regexp_replace ('foobarbaz', 'b..', 'X') I get 'fooXbaz' - it
replaces the string that matches given pattern with 'X', how do I
achieve the opposite - replace the string that doesn't match the
pattern ?

regards
mk


pgsql-sql by date:

Previous
From: "Marcin Stępnicki"
Date:
Subject: Re: How to change a view's owner in postgres
Next
From: "Pawel Socha"
Date:
Subject: Re: regexp_replace