"Jie Liang" <[EMAIL PROTECTED]> writes:
> 1. No doc said % should escape by %%, and
> select replace('whatever%20sites','%20','%%20') won't work also.
> 2. v7.3.2 haven't resolved this problem yet, I am not sure the later version.
In 7.3.3 release notes:
* Fix misbehavior of replace() on st
urldb=# select replace('whateveritis','a','A');
replace
--
whAteveritis
(1 row)
urldb=# select replace('whateveritis','e','E');
replace
--
whatEvEritis
(1 row)
urldb=# select replace('whatever%20itis','e','E');
replace
