Re: #escape_string_warning = off

The documentation about this is a little brief (reading from the
developer docs, section 4.1.2.1.).

Does the SQL standard provide no way to have a NULL character in a
string constant? Is single-quote the only special character?

If I have a system on 7.4 or 8.0 right now, what is the recommended
"right" way to write string constants with backslashes? I can't use E''
yet, so if I need to include a backslash it seems like there's no chance
it will be forward-compatible.

In the E'' constants, the special characters are only single-quote,
backslash, and NULL right?

Regards,
Jeff Davis

Marko Kreen wrote:
> On Mon, Aug 01, 2005 at 11:58:34AM -0700, Joshua D. Drake wrote:
>
>>What might this be?
>
>
> Whether to warn on '\' in non-E'' strings.
>
> AFAIK Bruce wants to turn this to 'on' in 8.2.
>