Re: Bug #712: Documentation Section 3.4 Binary Strings - Mailing list pgsql-bugs

From Joe Conway
Subject Re: Bug #712: Documentation Section 3.4 Binary Strings
Date
Msg-id 3D3447C4.2070405@joeconway.com
Whole thread Raw
In response to Bug #712: Documentation Section 3.4 Binary Strings  (pgsql-bugs@postgresql.org)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Jerome Alet
Date:
Subject: drop database doesn't work
Next
From: Tom Lane
Date:
Subject: Re: drop database doesn't work