"Jie Liang" <jie@stbernard.com> 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 strings containing '%'
regards, tom lane