Skip site navigation (1) Skip section navigation (2)

Re: How to implement word wrap

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to implement word wrap
Date: 2010-03-29 16:43:09
Message-ID: 20100329164309.GA12392@tux (view raw or flat)
Thread:
Lists: pgsql-general
Andrus <kobruleht2(at)hot(dot)ee> wrote:

> Database column contains large string without line feeds.
> How to split it with word wrap between words ?
> I tried to implement word wrap using
>
> create temp table test (line char(7));
> insert into test select repeat('aa ',10);
> select * from test;
>
> Expected result is that table test contains multiple rows and every row  
> contains two words:
>
> aa aa
>
> Instead I got string too long exception.
>
> How to implement word wrap in PostgreSql if  string contains words of any 
> size separated by spaces?

I think you have to write a function (plpgsql, plperl, ...), counting
chars per line and change space to newline if no more space in the line.
That's not really a SQL-problem ...

Maybe there are some perl-modules for that available, i don't know.



Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

In response to

pgsql-general by date

Next:From: Thom BrownDate: 2010-03-29 16:47:38
Subject: Re: How to implement word wrap
Previous:From: Thom BrownDate: 2010-03-29 16:42:47
Subject: Re: How to implement word wrap

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group