From aeb993bcca46740053111af4c710afd24dee2be2 Mon Sep 17 00:00:00 2001
From: Sam Morris <sam@robots.org.uk>
Date: Sun, 14 Nov 2010 20:02:08 +0100
Subject: Bug 611974: collectstats.pl --regenerate fails with PostgreSQL 8.4.x
 (sql_from_days() doesn't accept integers as argument) r/a=LpSolit

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

(limited to 'Bugzilla/DB/Pg.pm')

diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm
index c1c656a69..7802d58ef 100644
--- a/Bugzilla/DB/Pg.pm
+++ b/Bugzilla/DB/Pg.pm
@@ -151,7 +151,7 @@ sub sql_limit {
 sub sql_from_days {
     my ($self, $days) = @_;
 
-    return "TO_TIMESTAMP(${days}::int, 'J')::date";
+    return "TO_TIMESTAMP('$days', 'J')::date";
 }
 
 sub sql_to_days {
-- 
cgit v1.2.3-24-g4f1b