Is there a way to remove every character but numbers?

Поиск
Список
Период
Сортировка
От Andreas
Тема Is there a way to remove every character but numbers?
Дата
Msg-id 4F2E887D.3040108@gmx.net
обсуждение исходный текст
Ответы Re: Is there a way to remove every character but numbers?  (Viktor Bojović <viktor.bojovic@gmail.com>)
Список pgsql-sql
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.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: array dimensions, pg_catalog.pg_attribute and the \d command
Следующее
От: Viktor Bojović
Дата:
Сообщение: Re: Is there a way to remove every character but numbers?