Re: need a query
От | Timo Klecker |
---|---|
Тема | Re: need a query |
Дата | |
Msg-id | 006e01cacf22$71d6a310$5583e930$@de обсуждение исходный текст |
Ответ на | need a query (AI Rumman <rummandba@gmail.com>) |
Ответы |
Re: need a query
|
Список | 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:
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.
В списке pgsql-general по дате отправления: