From: Mark Wells <mark@freeside.biz>
Date: Thu, 18 Jul 2013 18:32:10 +0000 (-0700)
Subject: sales report: fix report class filtering under Pg 8.x, #24002
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=0fd6e4b7e096b1e53763b46656d392b04c802158

sales report: fix report class filtering under Pg 8.x, #24002
---

diff --git a/FS/FS/Report/Table.pm b/FS/FS/Report/Table.pm
index c5a6503c3..ffd2ac490 100644
--- a/FS/FS/Report/Table.pm
+++ b/FS/FS/Report/Table.pm
@@ -760,7 +760,9 @@ sub with_report_option {
   } elsif ( $num eq '0' ) {
     $comparison = "NOT EXISTS ($subselect)";
   } else {
-    $comparison = "(SELECT COALESCE(string_agg(num, ','), '') FROM (
+    #$comparison = "(SELECT COALESCE(string_agg(num, ','), '') FROM ( #Pg 9-ism
+    $comparison = "(SELECT COALESCE(array_to_string(array_agg(num), ','), '')
+    FROM (
     $subselect
     ) AS x) = '$num'";
   }