1- <!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.216 2007/11/08 13:13:51 petere Exp $ -->
1+ <!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.217 2007/11/21 04:01:37 tgl Exp $ -->
22
33 <chapter id="datatype">
44 <title id="datatype-title">Data Types</title>
@@ -3282,7 +3282,7 @@ SELECT 'a fat cat sat on a mat and ate a fat rat'::tsvector;
32823282
32833283 (As the example shows, the sorting is first by length and then
32843284 alphabetically, but that detail is seldom important.) To represent
3285- lexemes containing whitespace, surround them with quotes:
3285+ lexemes containing whitespace or punctuation , surround them with quotes:
32863286
32873287<programlisting>
32883288SELECT $$the lexeme ' ' contains spaces$$::tsvector;
@@ -3293,7 +3293,7 @@ SELECT $$the lexeme ' ' contains spaces$$::tsvector;
32933293
32943294 (We use dollar-quoted string literals in this example and the next one,
32953295 to avoid confusing matters by having to double quote marks within the
3296- literals.) Embedded quotescan be handled by doubling them :
3296+ literals.) Embedded quotesand backslashes must be doubled :
32973297
32983298<programlisting>
32993299SELECT $$the lexeme 'Joe''s' contains a quote$$::tsvector;