Re: BUG #1350: Backslash ecape charcter violates ISO/ANSI
Ken Johanson <ken@kensystem.com>
From: Ken Johanson <ken@kensystem.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: pgsql-bugs@postgresql.org
Date: 2004-12-17T15:21:24Z
Lists: pgsql-bugs
>We have a TODO item: > > * Allow backslash handling in quoted strings to be disabled for > portability > > The use of C-style backslashes (.e.g. \n, \r) in quoted strings is not > SQL-spec compliant, so allow such handling to be disabled. > >Unfortunately that's all we have. :-) > > > Thanks, glad to hear it's on the radar. From what I can tell it the broadest reaching standards incompatibility in the server. And, it's preventing some project managers from adopting the server as an alternative to the commercial ones (Its always been an easy-to-cite, and well justified concern that the backslash behavior is incompatible with other DBs and specs). Thx, ken