"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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
