[phpwiki-checkins] SF.net SVN: phpwiki:[7446] trunk/lib/WikiDB/backend/PearDB_ffpgsql.php

[<var...@us...>]

Revision: 7446
          http://phpwiki.svn.sourceforge.net/phpwiki/?rev=7446&view=rev
Author:   vargenau
Date:     2010-05-26 12:10:14 +0000 (Wed, 26 May 2010)

Log Message:
-----------
Use ts_rank (Postgres 8.4)

Modified Paths:
--------------
    trunk/lib/WikiDB/backend/PearDB_ffpgsql.php

Modified: trunk/lib/WikiDB/backend/PearDB_ffpgsql.php
===================================================================
--- trunk/lib/WikiDB/backend/PearDB_ffpgsql.php	2010-05-26 08:24:54 UTC (rev 7445)
+++ trunk/lib/WikiDB/backend/PearDB_ffpgsql.php	2010-05-26 12:10:14 UTC (rev 7446)
@@ -606,7 +606,7 @@
 
             $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 (";


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.