> is there a way to split up phone numbers?
> I know that's a tricky topic and it depends on the national
> phone number format.
> I'm especially interested in a solution for Germany, Swizerland and Austria.
> I've got everything in a phone number column that makes hardly sense like:
> 0049 4321 5678 0
> and so on...
> Those 3 samples are actually the same number in different notations.
> Aim would be to get a normalized number split up in 4 seperate columns
> so I end up with
> 49 4321 5678 0 for central
> 49 4321 5678 42 for Mr. Smith
> Is this doable?
> It would be a start to at least split off nr_nation and nr_city.
I seem to faintly remember that there are some anomalies in
the German area codes, i. e. "+49 xy" may be city A, with
"+49 xyz" being city B. Obviously, you will also not be
able to differentiate between normal and extension numbers
if they aren't properly marked up in the input.
In response to
pgsql-sql by date
|Next:||From: Marcin Krawczyk||Date: 2012-02-22 07:02:44|
|Subject: Re: Function definitions - batch update|
|Previous:||From: Ron Peterson||Date: 2012-02-21 20:51:30|
|Subject: on insert rule with default value|