Skip site navigation (1) Skip section navigation (2)

How to implement word wrap

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to implement word wrap
Date: 2010-03-29 16:36:55
Message-ID: 428B8E529EAF47D4A7D4599141E65B67@andrusnotebook (view raw or flat)
Thread:
Lists: pgsql-general
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. 


Responses

pgsql-general by date

Next:From: OgdenDate: 2010-03-29 16:42:38
Subject: Re: Warm Standby Setup Documentation
Previous:From: Andreas KretschmerDate: 2010-03-29 16:24:24
Subject: Re: How long will the query take

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group