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
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? |