replacing a word..

From: Anand Raman <araman(at)india-today(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: replacing a word..
Date: 2000-12-28 19:12:47
Message-ID: 20001229004247.Q32050@india-today.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi guys

I have to remove a entire word from a database column in a sql statement..

One of my database column contains strings like '###TOP_IMAGE###' ,
'###BOTTOM_IMAGE' , '###QUOTE###' and '###ACTIVITYBAR###'

This is later picked up by the rendering agent and the appropriate
HTML element is inserted in its place..

But i want to prohibit my full text indexer from seeing this text.

How can i replace all occurences of such strings with a zero length
string..

e.g
S ###TOP_IMAGE### pain's Davis Cup hero Juan Carlos Ferrero has withdrawn

should be seen by indexer as

Spain's Davis Cup hero Juan Carlos Ferrero has withdrawn

Is it possible.. I tried using translate() and the ~ operator to no
avail..

Could some please shed some light on this..

Thanx
Anand Raman

Browse pgsql-general by date

  From Date Subject
Next Message elein 2000-12-28 22:23:47 RE: Closest SQL dialect to PostgreSQL for ERwin?
Previous Message Francis Solomon 2000-12-28 18:05:14 RE: void UPDATE function?