From 485ad42eb9f1ca77e1ea53b8c4dadd2375dd4522 Mon Sep 17 00:00:00 2001
From: Matt Tyson <mtyson@redhat.com>
Date: Fri, 20 Mar 2015 15:55:07 +0800
Subject: [PATCH] Bug 1145459: SQL error under postgres when using 'blocks'
 column in buglist.cgi r=glob,a=glob

---
 Bugzilla/DB/Pg.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm
index 4ec95725de..47d43a4fe0 100644
--- a/Bugzilla/DB/Pg.pm
+++ b/Bugzilla/DB/Pg.pm
@@ -107,7 +107,7 @@ sub sql_group_concat {
         return "ARRAY_TO_STRING(ARRAY_AGG($text$order_by), $separator)";
     }
 
-    return "STRING_AGG($text, $separator$order_by)";
+    return "STRING_AGG(${text}::text, $separator${order_by}::text)"
 }
 
 sub sql_istring {
-- 
2.47.3