Re: replace single char for string using regexp_replace

2019-12-30 Thread Daniel Verite
PegoraroF10 wrote: > I have a > Replace(Replace(Replace(Replace($$Text,with;On'It"$$,',','chr(59)'),';','chr(44)'),'"','chr(34)'),,'chr(39)') > It works but I would like to call just one Replace. For performance, it might be the fastest method, despite the lack of elegance and the mul

Re: replace single char for string using regexp_replace

2019-12-29 Thread Tom Lane
PegoraroF10 writes: > I have to replace ; , " and ' chars in an string putting its correspondent > ascii value > I have a > Replace(Replace(Replace(Replace($$Text,with;On'It"$$,',','chr(59)'),';','chr(44)'),'"','chr(34)'),,'chr(39)') > It works but I would like to call just one Replace. Use t

replace single char for string using regexp_replace

2019-12-29 Thread PegoraroF10
I have to replace ; , " and ' chars in an string putting its correspondent ascii value I have a Replace(Replace(Replace(Replace($$Text,with;On'It"$$,',','chr(59)'),';','chr(44)'),'"','chr(34)'),,'chr(39)') It works but I would like to call just one Replace. I tried this but didn“t work select