|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.393 2007/09/1400:52:45 momjian Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.394 2007/09/1414: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 twobackslashes in an SQL statement (assuming escape |
2935 | | -stringsyntax is used). Thus, writing a pattern |
2936 | | -thatactually matches a literal backslash means writing four backslashes |
2937 | | -in thestatement. You can avoid this by selecting a different escape |
2938 | | -characterwith <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 |
|
|