diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-07-16 17:05:46 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-07-16 17:05:46 +0000 |
| commit | 93d6a8aa7d8d301e0c053b0275f0ea156c8f41a8 (patch) | |
| tree | 814ce6c77303e3d5be5c90fb7f36c3a829bc6667 | |
| parent | 3c7798f068ce2f334fee95fb125f0641eb10f725 (diff) | |
| download | postgresql-93d6a8aa7d8d301e0c053b0275f0ea156c8f41a8.tar.gz postgresql-93d6a8aa7d8d301e0c053b0275f0ea156c8f41a8.zip | |
> 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.
Joe Conway
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index d805439d830..cc50815059a 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.95 2002/07/16 04:45:59 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.96 2002/07/16 17:05:46 momjian Exp $ --> <chapter id="datatype"> @@ -1021,7 +1021,7 @@ SELECT b, char_length(b) FROM test2; <row> <entry> <literal> 39 </literal> </entry> <entry> single quote </entry> - <entry> <literal> '\\'' or '\\047' </literal> </entry> + <entry> <literal> '\'' or '\\047' </literal> </entry> <entry> <literal> select '\''::bytea; </literal></entry> <entry> <literal> ' </literal></entry> </row> @@ -1126,7 +1126,7 @@ SELECT b, char_length(b) FROM test2; <para> A single quote is a bit different in that it must be input as - <literal>'\''</literal> (or <literal>'\\134'</literal>), + <literal>'\''</literal> (or <literal>'\\047'</literal>), <emphasis>not</emphasis> as <literal>'\\''</literal>. This is because, while the literal parser interprets the single quote as a special character, and will consume the single backslash, the |