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@gmail.com -----------------------------------------------------------
Dreamers of the day are dangerous men,
because they make their dreams happen.
-----------------------------------------------------------