Обсуждение: Bug #712: Documentation Section 3.4 Binary Strings

David Clark (dclarknospam@opsi.co.za) reports a bug with a severity of 4
The lower the number the more severe it is.

Short Description
Documentation Section 3.4 Binary Strings

Long Description
In the user guide, section 3.4 binary strings

Table 3-7 SQL Literal escaped octets shows the input escape representation for a single quote as '\\'' , but the third
paragraphbelow table 3-8 SQL Output Escaped Octets says that the single quote must be input as '\''
 

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

Cheers
David.

Sample Code


No file was uploaded with this report

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