On 29 March 2010 17:42, Thom Brown <thombrown@xxxxxxxxx> wrote:
2010/3/29 Andrus <kobruleht2@xxxxxx>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
