really fix notify for Pg 8.3

[freeside.git] / FS / FS / Cron / notify.pm

diff --git a/FS/FS/Cron/notify.pm b/FS/FS/Cron/notify.pm
index c67fcc1..5b0e186 100644 (file)
--- 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