From: | "Timo Klecker" <klecker(at)decoit(dot)de> |
---|---|
To: | "'AI Rumman'" <rummandba(at)gmail(dot)com>, "'pgsql-general General'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: need a query |
Date: | 2010-03-29 09:30:17 |
Message-ID: | 006e01cacf22$71d6a310$5583e930$@de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ognjen Blagojevic | 2010-03-29 10:06:14 | Re: need a query |
Previous Message | Florent THOMAS | 2010-03-29 09:13:34 | Re: need a query |