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 - - -