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]