From: <var...@us...> - 2015-02-25 15:03:00
|
Revision: 9558 http://sourceforge.net/p/phpwiki/code/9558 Author: vargenau Date: 2015-02-25 15:02:48 +0000 (Wed, 25 Feb 2015) Log Message: ----------- Use plainto_tsquery Modified Paths: -------------- trunk/lib/WikiDB/backend/PearDB_ffpgsql.php Modified: trunk/lib/WikiDB/backend/PearDB_ffpgsql.php =================================================================== --- trunk/lib/WikiDB/backend/PearDB_ffpgsql.php 2015-02-24 15:21:23 UTC (rev 9557) +++ trunk/lib/WikiDB/backend/PearDB_ffpgsql.php 2015-02-25 15:02:48 UTC (rev 9558) @@ -621,9 +621,9 @@ $search_string = str_replace('%', '', $search_string); $search_clause = "substring(plugin_wiki_page.pagename from 0 for $len) = '$pat') AND ("; - $search_clause .= "idxFTI @@ to_tsquery('english', '$search_string')"; + $search_clause .= "idxFTI @@ plainto_tsquery('english', '$search_string')"; if (!$orderby) - $orderby = " ORDER BY ts_rank(idxFTI, to_tsquery('english', '$search_string')) DESC"; + $orderby = " ORDER BY ts_rank(idxFTI, plainto_tsquery('english', '$search_string')) DESC"; } else { $callback = new WikiMethodCb($searchobj, "_pagename_match_clause"); $search_clause = "substring(plugin_wiki_page.pagename from 0 for $len) = '$pat') AND ("; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |