Hi list, I'm trying to use regexp_replace to get rid of all occurrences of certain sub strings from my string. What I'm doing is:
SELECT regexp_replace('F0301 305-149-101-0 F0302 {x1} 12W47 0635H {tt}{POL23423423}', E'\{.+\}', '', 'g') so get rid of whatever is between { } along with these, but it results in: 'F0301 305-149-101-0 F0302 ' how do I get it to be: 'F0301 305-149-101-0 F0302 12W47 0635H' ?? as I understood the docs, the g flag "specifies replacement of each matching substring rather than only the first one" what am I missing ? regards mk