Re: [GENERAL] regexp_replace() [noindex] thing

2008-09-25 Thread Marcus Engene
Tom Lane wrote: Marcus Engene <[EMAIL PROTECTED]> writes: I would like to have a function like the above that returns "innan klas" for this data. I would have expected it to as I use the non greedy version. regression=# select regexp_replace ('innan[noindex]apa[/noindex]klas[noind

Re: [GENERAL] regexp_replace() [noindex] thing

2008-09-25 Thread Tom Lane
Marcus Engene <[EMAIL PROTECTED]> writes: > I would like to have a function like the above that returns "innan klas" > for this data. I would have expected it to as I use the non greedy version. regression=# select regexp_replace ('innan[noindex]apa[/noindex]klas[noindex]banan[/noindex]',

[GENERAL] regexp_replace() [noindex] thing

2008-09-25 Thread Marcus Engene
Hi! I'm using tsearch2 and sometimes there are blocks of text that shouldn't be indexed. There is a trigger function that gathers data from the usual suspects and updates the index. in this trigger, I'd like to exclude thing in a [noindex] tag: select regexp_replace ('innan[noindex]apa[