Re: Is there a way to remove every character but numbers?

On Sun, Feb 5, 2012 at 2:47 PM, Andreas <maps(dot)on(at)gmx(dot)net> wrote:

> Hi,
>
> I need to clean up a text column so that it just contains numbers or the
> "+" sign if it is the first character of the string.
>
> Well, it is needed to normalise up a phone number column.
> So it'd be great if the "+" could be transformed in "00" in the same step.
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-sql<http://www.postgresql.org/mailpref/pgsql-sql>
>

try regexp_replace

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me