Re: [Urgent] Regexp_replace question

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [Urgent] Regexp_replace question
Date: 2007-09-25 07:07:56
Message-ID: e373d31e0709250007s4415b696u6cbb2b150a50821d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 25/09/2007, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
> > How can I remove characters that form a part of regular expressions?
>
> Why do you want to do that?

Because these values were inserted into the DB due to a faulty
application. So cleansing was called for.

I just ended up doing it with replace instead of regexp_replace, one
character at a time.

Thanks!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Karalkar 2007-09-25 07:27:29 PgpoolAdmin installation
Previous Message Petri Simolin 2007-09-25 06:55:37 UNIQUE_VIOLATION exception, finding out which index would have been violated