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: [EMAIL PROTECTED]
-----------------------------------------------------------
Dreamers of the day are dangerous men,
because they make their dreams happen.
-----------------------------------------------------------
