Request a Demo
Home   >   mailing lists

Re: regexp_replace - Mailing list pgsql-sql

From Pawel Socha
Subject Re: regexp_replace
Date
Msg-id cc4f12900808010514id77c27dr7c91613f2b19005c@mail.gmail.com
Whole thread Raw
In response to regexp_replace  ("Marcin Krawczyk" <jankes.mk@gmail.com>)
Responses Re: regexp_replace
List pgsql-sql
Tree view
2008/8/1 Marcin Krawczyk <jankes.mk@gmail.com>
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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql



merlin=# SELECT regexp_replace ('foobarbaz', '[^b]', 'X', 'g');
 regexp_replace
----------------
 XXXbXXbXX
(1 row)


--
--
Serdecznie pozdrawiam

Pawel Socha
pawel.socha@gmail.com

programista/administrator

perl -le 's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%& -;^[%"`-{ a%%s%%$_%ee'

pgsql-sql by date:

Previous
From: "Marcin Krawczyk"
Date:
Subject: regexp_replace
Next
From: "Marcin Krawczyk"
Date:
Subject: Re: regexp_replace