pgsql-bugs@postgresql.org wrote:
> David Clark (dclarknospam@opsi.co.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