From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | Andreas <maps(dot)on(at)gmx(dot)net> |
Cc: | PostgresSQL list <pgsql-sql(at)postgresql(dot)org>, raju(at)linux-delhi(dot)org |
Subject: | Re: Funtion to clean up strings? |
Date: | 2009-02-18 13:05:46 |
Message-ID: | 87ocwz28ut.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Andreas <maps(dot)on(at)gmx(dot)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's PostgreSQL training!
From | Date | Subject | |
---|---|---|---|
Next Message | Shawn Tayler | 2009-02-19 15:41:11 | Creating a function with single quotes |
Previous Message | Andreas | 2009-02-18 12:32:14 | Re: How concat 3 strings if 2 are not empty? |