From db3d13029e2783cf79075fdcd6a02f8f4d79150f Mon Sep 17 00:00:00 2001
From: scyrma <scyrma>
Date: Wed, 6 Aug 2008 02:39:19 +0000
Subject: [PATCH] MDL-15345: Fix in sql query, for postgres. (merge from 1.9)

---
 tag/lib.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/tag/lib.php b/tag/lib.php
index 80630cd4e3..8c576b45d9 100644
--- a/tag/lib.php
+++ b/tag/lib.php
@@ -801,11 +801,11 @@ function tag_compute_correlations($min_correlation=2) {
 
         // query that counts how many times any tag appears together in items
         // with the tag passed as argument ($tag_id)
-        $query = "SELECT tb.tagid , COUNT(*) AS nr
+        $query = "SELECT tb.tagid 
                     FROM {tag_instance} ta JOIN {tag_instance} tb ON ta.itemid = tb.itemid
                    WHERE ta.tagid = ? AND tb.tagid <> ?
                 GROUP BY tb.tagid
-                  HAVING nr > ?
+                  HAVING COUNT(*) > ?
                 ORDER BY COUNT(*) DESC";
         $params = array($tag->id, $tag->id, $min_correlation);
 
-- 
2.39.5