Re: [HACKERS] possible replace() bug - postgres 7.3.1

[Joe Conway]

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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])