Re: Insert a space between each character
От
Michael Toews
Тема
Re: Insert a space between each character
Дата
Msg-id
48D0A8AD.10104@sfu.ca
Ответ на
Insert a space between each character (Nicholas I)
Список
Дерево обсуждения
Insert a space between each character "Nicholas I" <nicholas.domnic.i@gmail.com>
Re: Insert a space between each character "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: Insert a space between each character Michael Toews <mwtoews@sfu.ca>
Re: Insert a space between each character "Dirk Jagdmann" <jagdmann@gmail.com>
Hi,
Use a regular expression, e.g.:
select trim(regexp_replace('foobarbaz', '(.)', E'\\1 ', 'g'));
See http://www.postgresql.org/docs/8.3/static/functions-matching.html
for more.
+mt
Nicholas I wrote:
> Hi,
>
> can anybody help me, to insert a space between each character in
> postgresql.
>
> for example,
>
> ABC
>
> output
> A B C
>
> -Dominic
В списке pgsql-sql по дате отправления
