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.
pgsql-sql by date
|Next:||From: Viktor Bojović||Date: 2012-02-05 13:56:31|
|Subject: Re: Is there a way to remove every character but numbers?|
|Previous:||From: Dmitriy Igrishin||Date: 2012-02-03 20:21:49|
|Subject: Re: array dimensions, pg_catalog.pg_attribute and the \d command|