Hello,
The following statement replaces an asterisk in a string with a double-escaped asterisk:
SELECT regexp_replace('*',E'\\*',E'\\\\\\\\\*');
I got this result through experimentation and I am at a loss to explain why so much escaping is necessary for the third argument. Is there a better way?
Cheers,
M