Re: How to implement word wrap
От | Andreas Kretschmer |
---|---|
Тема | Re: How to implement word wrap |
Дата | |
Msg-id | 20100329164309.GA12392@tux обсуждение исходный текст |
Ответ на | How to implement word wrap ("Andrus" <kobruleht2@hot.ee>) |
Список | pgsql-general |
Andrus <kobruleht2@hot.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°
В списке pgsql-general по дате отправления: