Re: regexp_replace() function in new version - Mailing list pgsql-general

From Tom Lane
Subject Re: regexp_replace() function in new version
Date
Msg-id 6302.1195408764@sss.pgh.pa.us
Whole thread Raw
In response to regexp_replace() function in new version  (Abhijeet <abhijeetrathod262@gmail.com>)
List pgsql-general
Abhijeet <abhijeetrathod262@gmail.com> writes:
> 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');

I think you're expecting that the (?i option business will work
somewhere other than the start of the pattern.  It won't, and it
doesn't work in the style you've used it anyway.  See the manual:
http://www.postgresql.org/docs/8.2/static/functions-matching.html
particularly section 9.7.3.4.

            regards, tom lane

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Compressed Backup too big
Next
From: David Fetter
Date:
Subject: Re: GIN: any ordering guarantees for the hits returned?