pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: silly sad <sad@bankir.ru>
To: pgsql-sql@postgresql.org
Subject: Re: How do I remove selected words from text field?
Date: Fri, 02 Jul 2010 13:02:12 +0400
Message-ID: <4C2DAB14.1040309@bankir.ru> (raw)
In-Reply-To: <BLU0-SMTP6385CC10DC27B119CBC3FBACCD0@phx.gbl>
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>

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.

view thread (8+ messages)

Message-ID: <4C2DAB14.1040309@bankir.ru>
Permalink:  ../4C2DAB14.1040309@bankir.ru/
Also on:    postgresql.org/message-id/4C2DAB14.1040309@bankir.ru

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sad@bankir.ru
  Subject: Re: How do I remove selected words from text field?
  In-Reply-To: <4C2DAB14.1040309@bankir.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox