"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 strings containing '%' regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings