Re: Funtion to clean up strings? - Mailing list pgsql-sql

From Gregory Stark
Subject Re: Funtion to clean up strings?
Date
Msg-id 87ocwz28ut.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Funtion to clean up strings?  (Andreas <maps.on@gmx.net>)
List 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 by date:

Previous
From: Andreas
Date:
Subject: Re: How concat 3 strings if 2 are not empty?
Next
From: Shawn Tayler
Date:
Subject: Creating a function with single quotes