need a query

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: need a query
Date: 2010-03-02 11:57:10
Message-ID: 2a7905441003020357r12dcc4efh3cd6f2fd1bf48361@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have data as followos:

Table: contact
column: phone as varchar
+1 (800) 863-3950 ext. 517
+1.510.291.6100 ext2347
+1.714.545.8886 ext 144
714.545.8887 ext 144
714.545.8898
+1.510.291.6101

I need to extract only the phone numbers using a SQL query like:

+1 (800) 863-3950 ext. 517 ------- 8008603950
+1.510.291.6100 ext2347 -------- 5102916100
+1.714.545.8886 ext 144 --------- 7145458886
714.545.8887 ext 144 ----------- 7145458887
714.545.8898 -------------- 7145458898
+1.510.291.6101 ------------- 5102916101

What should be the sql?

Any help.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-03-02 12:00:59 Re: How to grant a user read-only access to a database?
Previous Message Simon Riggs 2010-03-02 11:53:28 Re: custom index