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.8 -r1.9
--- openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql 13 Mar 2009 18:57:19 -0000 1.8
+++ openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql 5 Nov 2010 16:35:10 -0000 1.9
@@ -37,6 +37,18 @@
+
+ postgresql8.3
+
+ select count(*)
+ from
+ [join $from_clauses ","]
+ $base_query
+ [expr {[llength $where_clauses] > 0 ? " and " : ""}]
+ [join $where_clauses " and "]
+
+
+
postgresql8.3
@@ -92,6 +104,18 @@
+
+ postgresql8.2
+
+ select count(*)
+ from
+ [join $from_clauses ","]
+ $base_query
+ [expr {[llength $where_clauses] > 0 ? " and " : ""}]
+ [join $where_clauses " and "]
+
+
+
postgresql8.0
Index: openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs.tcl,v
diff -u -r1.27 -r1.28
--- openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs.tcl 12 Jul 2009 01:12:33 -0000 1.27
+++ openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs.tcl 5 Nov 2010 16:35:10 -0000 1.28
@@ -179,7 +179,7 @@
set results_ids [db_list search {}]
- set count [db_string count "select count(*) from txt $base_query"]
+ set count [db_string count {}]
set stop_words [list]