From 44f1636ee248bd4b417855c30c6c8885f6889d55 Mon Sep 17 00:00:00 2001
From: martinlanghoff <martinlanghoff>
Date: Wed, 19 Sep 2007 07:28:43 +0000
Subject: [PATCH] datalib: get_categories() - remove PostgreSQL-ism

---
 lib/datalib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index ec489af32d..1bd6b3daa3 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -1207,7 +1207,7 @@ function get_categories($parent='none', $sort=NULL, $shallow=true) {
                 JOIN {$CFG->prefix}context ctx
                   ON cc.id=ctx.instanceid AND ctx.contextlevel=".CONTEXT_COURSECAT."
                 JOIN {$CFG->prefix}course_categories ccp
-                     ON (cc.path LIKE ccp.path||'%')
+                     ON (cc.path LIKE ".sql_concat('ccp.path',"'%'").")
                 WHERE ccp.id=$parent
                 $sort";
     }
-- 
2.39.5