Thread: excessive escaping in regular expression functions

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

On Jan 18, 2011, at 14:52, A.M. wrote:

> Is there a better way?

Use dollar quotes or standard quoting instead of E strings.


Michael Glaesemann
grzm seespotcode net