Home > mailing lists

need a query - Mailing list pgsql-general

From	AI Rumman
Subject	need a query
Date	March 2, 2010 10:57:23
Msg-id	2a7905441003020357r12dcc4efh3cd6f2fd1bf48361@mail.gmail.com Whole thread Raw
Responses	Re: need a query (Pavel Stehule <pavel.stehule@gmail.com>)
List	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.

From: Simon Riggs
Date: 02 March 2010, 10:53:50
Subject: Re: custom index

From: Thom Brown
Date: 02 March 2010, 11:02:31
Subject: Re: How to grant a user read-only access to a database?