Bug #712: Documentation Section 3.4 Binary Strings

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

Joe Conway wrote:

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.

Here's a patch to fix the binary string doc errors. It also adds two
missing </option> tags in pg_restore.sgml.

Please apply.

Thanks,

Joe

Patch applied. Your CVS must be old because the pg_restore.sgml problem
was fixed days ago.

---------------------------------------------------------------------------

Joe Conway wrote:

Joe Conway wrote:

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.

Here's a patch to fix the binary string doc errors. It also adds two
missing </option> tags in pg_restore.sgml.

Please apply.

Thanks,

Joe

[ application/x-gzip is not supported, skipping... ]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Bruce Momjian wrote:

Patch applied. Your CVS must be old because the pg_restore.sgml problem
was fixed days ago.

Yeah, it is from July 12th -- sorry. I'll get myself back up-to-date now.

Joe