From ff386b90bbee1abcf9e6cf38a9571e65f5e6a8b8 Mon Sep 17 00:00:00 2001 From: Steven Wittens Date: Mon, 28 Feb 2005 18:00:59 +0000 Subject: #17747: PGSQL improvements --- modules/search.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/search.module') diff --git a/modules/search.module b/modules/search.module index 5e519a4e0..1327e8bb7 100644 --- a/modules/search.module +++ b/modules/search.module @@ -511,7 +511,7 @@ function do_search($keys, $type, $join = '', $where = '1') { $count_query = "SELECT $count"; // Do pager query - $query = "SELECT i.type, i.sid, i.word, SUM(i.score/t.count) AS score FROM {search_index} i $join INNER JOIN {search_total} t ON i.word = t.word WHERE $where GROUP BY i.type, i.sid ORDER BY score DESC"; + $query = "SELECT i.type, i.sid, SUM(i.score/t.count) AS score FROM {search_index} i $join INNER JOIN {search_total} t ON i.word = t.word WHERE $where GROUP BY i.type, i.sid ORDER BY score DESC"; $result = pager_query($query, 15, 0, $count_query, $arguments); $results = array(); -- cgit v1.2.3