Envelope-to: pgsql-sql@postgresql.org
Message-ID: <4C2DAB14.1040309@bankir.ru>
Date: Fri, 02 Jul 2010 13:02:12 +0400
From: silly sad <sad@bankir.ru>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5)
	Gecko/20100111 Thunderbird/3.0
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: How do I remove selected words from text field?
References: <BLU0-SMTP789E97372809C06816956AACC70@phx.gbl>
	<AANLkTil2rYpIoIisIGZpEmpIILCV9syw_yGzuN89drOG@mail.gmail.com>
	<BLU0-SMTP15F262059DF646A24B8853ACC80@phx.gbl>
	<BLU0-SMTP7888ACA3DFCEDA21C88B69ACCD0@phx.gbl>
	<AANLkTim8AiMOEQhd8vkBlc7p7JqYToqH140CJ4v_NWk8@mail.gmail.com>
	<BLU0-SMTP6385CC10DC27B119CBC3FBACCD0@phx.gbl>
In-Reply-To: <BLU0-SMTP6385CC10DC27B119CBC3FBACCD0@phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 07/02/10 03:25, Frank Bax wrote:
> Osvaldo Kussama wrote:
>> 2010/7/1 Frank Bax <fbax@sympatico.ca>:
>>> Create some tables; then add some data:
>>>
>>> create table t1 (i int, v varchar);
>>> insert into t1 values(1,'A B C D');
>>> insert into t1 values(2,'B D E F');
>>> insert into t1 values(3,'G H I J');
>>> insert into t1 values(4,'E');

first of all rebuild the table.
explode these strings by space char
and put into another table for convenient use

In other words
construct proper data scheme PRIOR TO USE it.