Re: [GENERAL] regexp_replace() function in new version

2007-11-18 Thread Tom Lane
Abhijeet <[EMAIL PROTECTED]> writes: > I have tried following regex in & function: >- SELECT regexp_replace('Abhijeet', > > '<(\s)*/?(?i:script|i|b|u|embed|object|a|frameset|frame|iframe|meta|link|style|table|th|td|tr|tbody|input|select|option|form|map|area|!--)(.|\n)*?>', >'\&\s'); I

Re: [GENERAL] regexp_replace() function in new version

2007-11-17 Thread Scott Marlowe
On Nov 14, 2007 7:53 AM, Abhijeet <[EMAIL PROTECTED]> wrote: > Hi, > > regexp_replace() function in new version of PostgreSQL is giving error. > > I am trying to remove tags from string. > > I have tried following regex in & function: > > SELECT regexp_replace('Abhijeet', > '<(\s)*/?(?i:script|i|b|

[GENERAL] regexp_replace() function in new version

2007-11-17 Thread Abhijeet
Hi, regexp_replace() function in new version of PostgreSQL is giving error. I am trying to remove tags from string. I have tried following regex in & function: - SELECT regexp_replace('Abhijeet', '<(\s)*/?(?i:script|i|b|u|embed|object|a|frameset|frame|iframe|meta|link|style|table|th|td|t