> Use a regular expression, e.g.:
> select trim(regexp_replace('foobarbaz', '(.)', E'\\1 ', 'g'));
And if we only match characters until the last character in the
string, we can get rid of the outer trim():
# select regexp_replace('foobarbaz', E'(.)(?!$)', E'\\1 ', 'g');
regexp_replace
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.
>
>
am Wed, dem 17.09.2008, um 11:49:27 +0530 mailte Nicholas I folgendes:
> Hi,
>
> can anybody help me, to insert a space between each character in postgresql.
>
> for example,
>
> ABC
>
> output
> A B C
write a function in plpgsql, you can use string-function like substr to
split the st
Hi,
can anybody help me, to insert a space between each character in
postgresql.
for example,
ABC
output
A B C
-Dominic
