Index: openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql 7 Aug 2017 23:48:29 -0000 1.12
+++ openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql 7 Nov 2017 09:33:21 -0000 1.13
@@ -86,31 +86,6 @@
-
- postgresql8.0
-
- insert into txt (object_id,fti)
- values (:object_id,
- setweight(to_tsvector('default',coalesce(:title,'')),'A')
- ||setweight(to_tsvector('default',coalesce(:keywords,'')),'B')
- ||to_tsvector('default',coalesce(:txt,'')))
-
-
-
-
- postgresql8.0
-
- select txt.object_id
- from
- [join $from_clauses ","]
- $base_query
- [expr {[llength $where_clauses] > 0 ? " and " : ""}]
- [join $where_clauses " and "]
- order by rank(fti,to_tsquery('default',:query)) desc
- $limit_clause $offset_clause
-
-
-
postgresql8.2
@@ -123,22 +98,4 @@
-
- postgresql8.0
-
- select headline('default',:txt,to_tsquery('default',:query))
-
-
-
-
- postgresql8.0
-
- update txt set fti =
- setweight(to_tsvector('default',coalesce(:title,'')),'A')
- ||setweight(to_tsvector('default',coalesce(:keywords,'')),'B')
- ||to_tsvector('default',coalesce(:txt,''))
- where object_id=:object_id
-
-
-