From 9ddbd40c8fc8244e52981a90247c68c06f46ef5b Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Sat, 12 Mar 2005 03:06:11 +0000
Subject: Bug 285678: NOT(integer) not supported by postgres Patch By Tomas
 Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=myk

---
 CGI.pl           | 2 +-
 editproducts.cgi | 2 +-
 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";
-- 
cgit v1.2.1