Re: possible replace() bug - postgres 7.3.1 - Mailing list pgsql-hackers

Hannu Krosing wrote:
> Ryan Mahoney kirjutas N, 06.11.2003 kell 23:03:
>>I am running PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96
> what does just
> 
> SELECT replace(data, '\'', '\'\'')
>   FROM temp_sales_lead
>  ORDER BY id, row LIMIT 10; 
> 
> produce ?

There was a bug in replace(), fixed by Tom in 7.3.3 I think (for sure by 
7.3.4). If you have any embedded "%" characters in data, it would 
trigger the bug. Try upgrading to 7.3.4.

HTH,

Joe