Re: Bug #712: Documentation Section 3.4 Binary Strings

pgsql-bugs(at)postgresql(dot)org wrote:
> David Clark (dclarknospam(at)opsi(dot)co(dot)za) reports a bug with a severity
> Table 3-7 SQL Literal escaped octets shows the input escape
> representation for a single quote as '\\'' , but the third paragraph
> below table 3-8 SQL Output Escaped Octets says that the single quote
> must be input as '\''

Nice catch. '\'' is correct as shown in the example in Table 3-7.

>
> Also in the same paragraph mentioned above it says input for the
> single quote must be '\'' (or '\\134') shouldn't this be (or '\\047')

Also a bug. Should be '\\047', as you pointed out.

Thanks for the report! I'll submit a patch.

Joe