Re: regexp_replace() function in new version

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: regexp_replace() function in new version
Дата
Msg-id dcc563d10711171753rde8df1fl668dbf9495404dda@mail.gmail.com
обсуждение исходный текст
Ответ на regexp_replace() function in new version  (Abhijeet <abhijeetrathod262@gmail.com>)
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: Chunk Delete
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: ERROR: invalid restriction selectivity: 224359728.000000