From 875c69f649f1e285de5bb207cf945f591606d7b0 Mon Sep 17 00:00:00 2001 From: vargenau Date: Wed, 26 May 2010 12:10:14 +0000 Subject: [PATCH] Use ts_rank (Postgres 8.4) git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@7446 96ab9672-09ca-45d6-a79d-3d69d39ca109 --- lib/WikiDB/backend/PearDB_ffpgsql.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/WikiDB/backend/PearDB_ffpgsql.php b/lib/WikiDB/backend/PearDB_ffpgsql.php index 1ff6fafc2..a0e2055d1 100644 --- a/lib/WikiDB/backend/PearDB_ffpgsql.php +++ b/lib/WikiDB/backend/PearDB_ffpgsql.php @@ -606,7 +606,7 @@ extends WikiDB_backend_PearDB_pgsql $search_clause .= "idxFTI @@ to_tsquery('$search_string')"; if (!$orderby) - $orderby = " ORDER BY rank(idxFTI, to_tsquery('$search_string')) DESC"; + $orderby = " ORDER BY ts_rank(idxFTI, to_tsquery('$search_string')) DESC"; } else { $callback = new WikiMethodCb($searchobj, "_pagename_match_clause"); $search_clause = "substring(plugin_wiki_page.pagename from 0 for $len) = '$pat') AND ("; -- 2.45.0