1- <!-- $PostgreSQL: pgsql/doc/src/sgml/textsearch.sgml,v 1.40 2007/12/13 06:32:47 tgl Exp $ -->
1+ <!-- $PostgreSQL: pgsql/doc/src/sgml/textsearch.sgml,v 1.41 2008/03/04 03:17:18 momjian Exp $ -->
22
33<chapter id="textsearch">
44 <title id="textsearch-title">Full Text Search</title>
@@ -1102,7 +1102,7 @@ StartSel=<b>, StopSel=</b>, MaxWords=35, MinWords=15, ShortWord=3, H
11021102 For example:
11031103
11041104<programlisting>
1105- SELECT ts_headline('The most common type of search
1105+ SELECT ts_headline('english', ' The most common type of search
11061106is to find all documents containing given query terms
11071107and return them in order of their similarity to the
11081108query.', to_tsquery('query & similarity'));
@@ -1112,7 +1112,7 @@ query.', to_tsquery('query & similarity'));
11121112 and return them in order of their <b>similarity</b> to the
11131113 <b>query</b>.
11141114
1115- SELECT ts_headline('The most common type of search
1115+ SELECT ts_headline('english', ' The most common type of search
11161116is to find all documents containing given query terms
11171117and return them in order of their similarity to the
11181118query.',
@@ -1135,8 +1135,8 @@ query.',
11351135 example:
11361136
11371137<programlisting>
1138- SELECT id, ts_headline(body,q), rank
1139- FROM (SELECT id, body, q, ts_rank_cd(ti,q) AS rank
1138+ SELECT id, ts_headline(body,
1139+ FROM (SELECT id, body, q, ts_rank_cd(ti,
11401140 FROM apod, to_tsquery('stars') q
11411141 WHERE ti @@ q
11421142 ORDER BY rank DESC LIMIT 10) AS foo;