Abhijeet <abhijeetrathod262@gmail.com> writes:
> I have tried following regex in & function:
> - SELECT regexp_replace('<i>Abhijeet</b>',
>
'<(\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 think you're expecting that the (?i option business will work
somewhere other than the start of the pattern. It won't, and it
doesn't work in the style you've used it anyway. See the manual:
http://www.postgresql.org/docs/8.2/static/functions-matching.html
particularly section 9.7.3.4.
regards, tom lane