summaryrefslogtreecommitdiff
path: root/contrib/tsearch2/sql
diff options
context:
space:
mode:
authorTeodor Sigaev2004-06-28 16:19:09 +0000
committerTeodor Sigaev2004-06-28 16:19:09 +0000
commitbb89237531439816c3f8d59b7b1891735e5f1f47 (patch)
treeafe5ab2775f14d1cd7652f38f909ba9ca15ced56 /contrib/tsearch2/sql
parente48cfacb8414231db82dc930995492085a260fc7 (diff)
1 Eliminate duplicate field HLWORD->skip
2 Rework support for html tags in parser 3 add HighlightAll to headline function for generating highlighted whole text with saved html tags
Diffstat (limited to 'contrib/tsearch2/sql')
-rw-r--r--contrib/tsearch2/sql/tsearch2.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/contrib/tsearch2/sql/tsearch2.sql b/contrib/tsearch2/sql/tsearch2.sql
index 231ddaebe5e..0a980608f7c 100644
--- a/contrib/tsearch2/sql/tsearch2.sql
+++ b/contrib/tsearch2/sql/tsearch2.sql
@@ -253,6 +253,20 @@ The sculpture of these granite seams,
Upon a woman s face. E. J. Pratt (1882 1964)
', to_tsquery('sea'));
+
+select headline('
+<html>
+<!-- some comment -->
+<body>
+Sea view wow <u>foo bar</u> <i>qq</i>
+<a href="http://www.google.com/foo.bar.html" target="_blank">YES &nbsp;</a>
+ff-bg
+<script>
+ document.write(15);
+</script>
+</body>
+</html>',
+to_tsquery('sea&foo'), 'HighlightAll=true');
--check debug
select * from ts_debug('Tsearch module for PostgreSQL 7.3.3');