Re: [GENERAL] [Urgent] Regexp_replace question

From: Michael Fuhr <mike(at)fuhr.org>
Date: Tue Sep 25 2007 - 02:46:38 EDT

On Tue, Sep 25, 2007 at 01:36:26PM +0800, Phoenix Kiula wrote:
> How can I remove characters that form a part of regular expressions?

Why do you want to do that?

> I would like to remove all instances of the following characters:
>
> [
> ]
> \
> +

test=> select id, t, regexp_replace(t, e'[\\\\[\\]+]', '', 'g') from foo;  id | t | regexp_replace

----+------------+----------------

  1 | foo[]+\bar | foobar
(1 row)

test=> select id, t, translate(t, e'[]\\+', '') from foo;  id | t | translate
----+------------+-----------
  1 | foo[]+\bar | foobar
(1 row)

-- 
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Received on Tue Sep 25 02:50:36 2007