Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit93d6a8a

Browse files
committed
> 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
1 parent3c7798f commit93d6a8a

File tree

1 file changed

+3
-3
lines changed

1 file changed

+3
-3
lines changed

‎doc/src/sgml/datatype.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.95 2002/07/1604:45:59 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.96 2002/07/1617:05:46 momjian Exp $
33
-->
44

55
<chapter id="datatype">
@@ -1021,7 +1021,7 @@ SELECT b, char_length(b) FROM test2;
10211021
<row>
10221022
<entry> <literal> 39 </literal> </entry>
10231023
<entry> single quote </entry>
1024-
<entry> <literal> '\\'' or '\\047' </literal> </entry>
1024+
<entry> <literal> '\'' or '\\047' </literal> </entry>
10251025
<entry> <literal> select '\''::bytea; </literal></entry>
10261026
<entry> <literal> ' </literal></entry>
10271027
</row>
@@ -1126,7 +1126,7 @@ SELECT b, char_length(b) FROM test2;
11261126

11271127
<para>
11281128
A single quote is a bit different in that it must be input as
1129-
<literal>'\''</literal> (or <literal>'\\134'</literal>),
1129+
<literal>'\''</literal> (or <literal>'\\047'</literal>),
11301130
<emphasis>not</emphasis> as <literal>'\\''</literal>. This is because,
11311131
while the literal parser interprets the single quote as a special
11321132
character, and will consume the single backslash, the

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp