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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly