Re: [GENERAL] need a query

2010-03-29 Thread Ognjen Blagojevic
Mit freundlichen Grüßen Timo Klecker * * * * *Von:* pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] *Im Auftrag von *AI Rumman *Gesendet:* Montag, 29. März 2010 10:45 *An:* pgsql-general General *Betreff:* [GENERAL] need a query I need a query to

Re: [GENERAL] need a query

2010-03-29 Thread Timo Klecker
-str ing-field-in-a-postgresql-group-by-query Mit freundlichen Grüßen Timo Klecker Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] Im Auftrag von AI Rumman Gesendet: Montag, 29. März 2010 10:45 An: pgsql-general General Betreff: [GENE

Re: [GENERAL] need a query

2010-03-29 Thread Florent THOMAS
and what abourt that : http://www.postgresql.org/docs/8.4/interactive/functions-string.html Le lundi 29 mars 2010 à 14:44 +0600, AI Rumman a écrit : > I need a query to get the initial letter of the words: > Like: > > Ispahani Public School IPS > Ahmed Iftekhar AI > > Any

[GENERAL] need a query

2010-03-29 Thread AI Rumman
I need a query to get the initial letter of the words: Like: Ispahani Public School IPS Ahmed Iftekhar AI Any help please.

Re: [GENERAL] need a query

2010-03-02 Thread Pavel Stehule
2010/3/2 AI Rumman : > 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 lik

[GENERAL] need a query

2010-03-02 Thread AI Rumman
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 --- 80