Re: regexp_replace() function in new version

On Nov 14, 2007 7:53 AM, Abhijeet <abhijeetrathod262@gmail.com> wrote:
> 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?

I think PostgreSQL is telling what's happening in the hint there.  Put
an E in front of your strings if you're going to have escapes in them.