1
- <!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.393 2007/09/14 00:52:45 momjian Exp $ -->
1
+ <!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.394 2007/09/14 14:54:25 momjian Exp $ -->
2
2
3
3
<chapter id="functions">
4
4
<title>Functions and Operators</title>
@@ -2929,14 +2929,14 @@ cast(-44 as bit(12)) <lineannotation>111111010100</lineannotation>
2929
2929
</para>
2930
2930
2931
2931
<para>
2932
- Note that the backslash already has a special meaning in string
2933
- literals, so to write a pattern constant that contains a backslash
2934
- you must write two backslashes in an SQL statement (assuming escape
2935
- string syntax is used ). Thus, writing a pattern
2936
- that actually matches a literal backslash means writing four backslashes
2937
- in the statement. You can avoid this by selecting a different escape
2938
- character with <literal>ESCAPE</literal>; then a backslash is not special
2939
- to <function>LIKE</function> anymore. (But it is still special to the string
2932
+ Note that the backslash already has a special meaning in string literals,
2933
+ so to write a pattern constant that contains a backslash you must write two
2934
+ backslashes in an SQL statement (assuming escape string syntax is used, see
2935
+ <xref linkend="sql- syntax-strings"> ). Thus, writing a pattern that
2936
+ actually matches a literal backslash means writing four backslashes in the
2937
+ statement. You can avoid this by selecting a different escape character
2938
+ with <literal>ESCAPE</literal>; then a backslash is not special to
2939
+ <function>LIKE</function> anymore. (But it is still special to the string
2940
2940
literal parser, so you still need two of them.)
2941
2941
</para>
2942
2942
@@ -3549,7 +3549,7 @@ SELECT foo FROM regexp_split_to_table('the quick brown fox', E'\\s*') AS foo;
3549
3549
meaning in <productname>PostgreSQL</> string literals.
3550
3550
To write a pattern constant that contains a backslash,
3551
3551
you must write two backslashes in the statement, assuming escape
3552
- string syntax is used.
3552
+ string syntax is used (see <xref linkend="sql-syntax-strings">) .
3553
3553
</para>
3554
3554
</note>
3555
3555
0 commit comments