On 29 March 2010 17:42, Thom Brown <thombr...@gmail.com> wrote:
> 2010/3/29 Andrus <kobrule...@hot.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
>
Just realised that's not what you're after, but my first point still stands.
Thom
