From 8501359ef08b7318b6b039eeca28b8acc02d136e Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Sun, 29 Jan 2012 13:28:33 +0100 Subject: [PATCH] Don't confuse total number of pages with total number of hits --- tools/search/sql/functions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tools/search/sql/functions.sql b/tools/search/sql/functions.sql index b1f858ff..9d0ffea3 100644 --- a/tools/search/sql/functions.sql +++ b/tools/search/sql/functions.sql @@ -102,7 +102,7 @@ BEGIN END IF; RETURN QUERY SELECT hit.siteid, hit.baseurl::text, hit.suburl::text, webpages.title::text, ts_headline(webpages.txt,tsq,'StartSel="[[[[[[",StopSel="]]]]]]"'), hit.ts_rank_cd::float FROM webpages WHERE webpages.site=hit.siteid AND webpages.suburl=hit.suburl; END LOOP; - RETURN QUERY SELECT pagecount, NULL::text, NULL::text, NULL::text, NULL::text, pagecount::float; + RETURN QUERY SELECT pagecount, NULL::text, NULL::text, NULL::text, NULL::text, hits::float; END; $$ LANGUAGE 'plpgsql'; -- 2.39.5