Re: Funtion to clean up strings?

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Funtion to clean up strings?
Дата
Msg-id 87ocwz28ut.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: Funtion to clean up strings?  (Andreas <maps.on@gmx.net>)
Список pgsql-sql
Andreas <maps.on@gmx.net> writes:

> Hi
> Thanks, that really works   :)
>
> Now a last extension.
> Some numbers were entered in a "110% perfect" way with an excessive (0).  +49
> (0) 123 / 456 789
> I have to suspect the source liked to express that it's either +49  or  0 if
> the +49 isn't applicable, but not both.

This is the standard format for phone numbers. Parenthesized digits -- as you
suspected -- represent digits which must only be dialled when using the number
locally and must be omitted from outside.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about
EnterpriseDB'sPostgreSQL training!
 


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

Предыдущее
От: Andreas
Дата:
Сообщение: Re: How concat 3 strings if 2 are not empty?
Следующее
От: Shawn Tayler
Дата:
Сообщение: Creating a function with single quotes