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?
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);
In response to
pgsql-general by date
|Next:||From: Andreas Kretschmer||Date: 2010-03-29 16:43:09|
|Subject: Re: How to implement word wrap|
|Previous:||From: Chris Barnes||Date: 2010-03-29 16:42:46|
|Subject: Processor speed relative to postgres transactions per second|