Abhijeet <abhijeetrathod262@xxxxxxxxx> 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@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
