Bug 285678: NOT(integer) not supported by postgres

Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=myk

2 files changed, 2 insertions, 2 deletions

diff --git a/CGI.pl b/CGI.pl
index 8d42eb4cc..31ed48e3d 100644
--- a/CGI.pl
+++ b/CGI.pl
@@ -304,7 +304,7 @@ sub GetBugActivity {
     if (Param("insidergroup") && !UserInGroup(Param('insidergroup'))) {
         $suppjoins = "LEFT JOIN attachments 
                    ON attachments.attach_id = bugs_activity.attach_id";
-        $suppwhere = "AND NOT(COALESCE(attachments.isprivate,0))"; 
+        $suppwhere = "AND COALESCE(attachments.isprivate, 0) = 0";
     }
     my $query = "
         SELECT COALESCE(fielddefs.description, bugs_activity.fieldid),
diff --git a/editproducts.cgi b/editproducts.cgi
index db391228b..ea4bc5e5b 100755
--- a/editproducts.cgi
+++ b/editproducts.cgi
@@ -339,7 +339,7 @@ unless ($action) {
 
     my $query = "SELECT products.name,
                         COALESCE(products.description,'') AS description, 
-                        NOT(disallownew) AS status,
+                        disallownew = 0 AS status,
                         votesperuser,  maxvotesperbug, votestoconfirm,
                         COUNT(bug_id) AS bug_count
                  FROM products";