need a query

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 :

Try this:

SELECT regexp_matches('foobar beque bazil barf bonk', '(\\m.)', 'g')

Now you have the first letters, you can use array_to_string to get an string
and use concat_str after this:

http://stackoverflow.com/questions/43870/how-to-concatenate-strings-of-a-str
ing-field-in-a-postgresql-group-by-query

Mit freundlichen Grüßen

Timo Klecker

Von: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@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 get the initial letter of the words:
Like:

Ispahani Public School -------- IPS
Ahmed Iftekhar -------- AI

Any help please.

If you are sure that your words are space delimited, you may use this:

select regexp_replace('Ispahani Public School'||' ', '([^ ])([^ ]* )',
'\\1', 'g');

Regards,
Ognjen

Timo Klecker wrote: