regexp_replace() function in new version

[Abhijeet <abhijeetrathod262@xxxxxxxxx>]

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('<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');
• cc SELECT regexp_replace('<i>Abhijeet</b>', '< */?(?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)*?>', '\& ' );

Both these try giving me error as follows:

• WARNING:  nonstandard use of escape in a string literal at character 42
  HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
  WARNING:  nonstandard use of escape in a string literal at character 192
  HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
  ERROR:  invalid regular _expression_: quantifier operand invalid

can anyone suggest me why is that error ocurring?

----
Thanks &  Regards,
Abhijeet G. Rathod
Software Engineer -(SCWCD)
Mail: abhijeetrathod262@xxxxxxxxx
-----------------------------------------------------------
Dreamers of the day are dangerous men,
because they make their dreams happen.
-----------------------------------------------------------