Re: How to implement word wrap

2010/3/29 Andrus <kobruleht2(at)hot(dot)ee>

> 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?
>
> Andrus.
>
> --
>

No, what you've done is asked it to insert 'aa aa aa aa aa aa aa aa aa aa'.

I suspect you're looking for:

INSERT INTO test SELECT 'aa' FROM generate_series(1,10);

Regards

Thom