| 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: | Whole Thread | Raw Message | 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? |