| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Abhijeet <abhijeetrathod262(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: regexp_replace() function in new version |
| Date: | 2007-11-18 17:59:24 |
| Message-ID: | 6302.1195408764@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Abhijeet <abhijeetrathod262(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2007-11-18 17:59:41 | Re: GIN: any ordering guarantees for the hits returned? |
| Previous Message | Shane Ambler | 2007-11-18 17:55:23 | Re: Compressed Backup too big |