From 7889bec2b0f951c053b06ef45fbc60dacd3f8a88 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Tue, 31 Mar 2009 19:51:54 +0000
Subject: [PATCH] really fix notify for Pg 8.3

---
 FS/FS/Cron/notify.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/FS/FS/Cron/notify.pm b/FS/FS/Cron/notify.pm
index c67fcc19a..5b0e186ad 100644
--- a/FS/FS/Cron/notify.pm
+++ b/FS/FS/Cron/notify.pm
@@ -62,7 +62,7 @@ END
       0 = ( select count(*) from cust_pkg_option
               where cust_pkg.pkgnum = cust_pkg_option.pkgnum
                 and cust_pkg_option.optionname = 'impending_recur_notification_sent'
-                and cust_pkg_option.optionvalue = 1
+                and CAST( cust_pkg_option.optionvalue AS INTEGER ) = 1
           )
 END
   
-- 
2.11.0