http://issues.apache.org/SpamAssassin/show_bug.cgi?id=5299
------- Additional Comments From [EMAIL PROTECTED] 2007-01-18 10:23 ------- > Can you confirm if this works on earlier version of PostgreSQL? The E'...' syntax was introduced with PostgreSQL 8.1 (2005-11-08): http://www.postgresql.org/docs/8.1/interactive/release-8-1.html * Add E'' syntax so eventually ordinary strings can treat backslashes literally (Bruce) Currently PostgreSQL processes a backslash in a string literal as introducing a special escape sequence, e.g. \n or \010. While this allows easy entry of special values, it is nonstandard and makes porting of applications from other databases more difficult. For this reason, the PostgreSQL project is planning to remove the special meaning of backslashes in strings. [...] Note: While ordinary strings now support C-style backslash escapes, future versions will generate warnings for such usage and eventually treat backslashes as literal characters to be standard-conforming. The proper way to specify escape processing is to use the escape string syntax to indicate that escape processing is desired. Escape string syntax is specified by writing the letter E (upper or lower case) just before the string, e.g. E'\041'. This method will work in all future versions of PostgreSQL. ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee.
