[Urgent] Regexp_replace question - Mailing list pgsql-general

From Phoenix Kiula
Subject [Urgent] Regexp_replace question
Date
Msg-id e373d31e0709242236g242332f6q71b835d78209badb@mail.gmail.com
Whole thread Raw
Responses Re: [Urgent] Regexp_replace question  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Hi,

How can I remove characters that form a part of regular expressions? I
would like to remove all instances of the following characters:

[
]
\
+

Given that these all mean something in regexp, I am trying to prefix
them with a backslash, but it doesn't work. I tried the following:

    update TABLE
    set COLUMN = regexp_replace(COLUMN, E'[\\\[\]\+]+', '')
    ;

This did not work so I tried the naked characters separated by a pipe,
as follows:

    update TABLE
    set COLUMN= regexp_replace(COLUMN, E'[\|[|]|+]+', '')
    ;

But this of course did not work either. I've read and re-read the
pattern matching doc page ( http://snipurl.com/pg_regexp ) but it
doesn't seem to offer much help.

Any thoughts on what I am doing wrong?

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Why the ERROR: duplicate key violates uniqueconstraint "master_pkey" is raised? - Is this a Bug?
Next
From: Michael Fuhr
Date:
Subject: Re: [Urgent] Regexp_replace question